CALCULATETABLE Evaluates a table expression in a context modified by the given filters.
Expression** – The table expression to be evaluated
Filter1, filter2,… – A Boolean expression or a table expression that defines a filter
The expression used as the first parameter must be a function that returns a table.
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 calculates a scalar value.
A table of values.