CALCULATE Evaluates an expression in a context that is modified by the specified filters.
Expression – The expression to be evaluated.
Filter1, filter2,… – (optional) A comma separated list of Boolean expression or a table expression that defines a filter.
The expression used as the first parameter is essentially the same as a measure.
The following restrictions apply to Boolean expressions that are used as arguments:
The expression cannot reference a measure.
The expression cannot use a nested CALCULATE function.
The expression cannot use any function that scans a table or returns a table, including aggregation functions.
However, a Boolean expression can use any function that looks up a single value, or that calculate a scalar value.
The value that is the result of the expression.