CALCULATETABLE

CALCULATETABLE Evaluates a table expression in a context modified by the given filters.


Syntax

CALCULATETABLE(expression,filter1,filter2,…)

Parameters

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

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Filter Functions / CALCULATETABLE