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.

Return Value

A table of values.

Reference Data

DAX Functions / Filter Functions / CALCULATETABLE