CALCULATE
Evaluates an expression in a context modified by filters.
Syntax
CALCULATE(<expr>, <filter>)
| Parameter | Type | Description |
|---|---|---|
| expr | any | The expression to be evaluated. |
| filter | Boolean | A boolean (True/False) expression. |
CALCULATE(<expr>, <filter>)
| Parameter | Type | Description |
|---|---|---|
| expr | any | The expression to be evaluated. |
| filter | Table | A table expression that defines a filter. |
Return values
Depends on input arguments.
Examples
CALCULATE(orders.total_amount, YEAR(orders.created_at) == 2022)
CALCULATE(orders.total_amount, AND(products.vendor == "Various", customers.type == "Returning"))
CALCULATE(orders.total_amount, ALL(orders))
CALCULATE(orders.total_amount, FILTER(orders, orders.discount > 0))