Works like CALCULATE but returns a table: a table expression is evaluated under a modified filter context, with filter arguments behaving exactly as they do for CALCULATE.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains CALCULATETABLE in context, with comparison tables and the common traps.
Terms in this definition
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- CALCULATE
A DAX function that computes an expression after changing the filter context with filter modifiers, Boolean filters or table filters. Called with no filters, it still turns any row context into filter context, which is known as context transition.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Filter context
Whenever DAX evaluates an expression, each column is limited to certain values by slicers, report filters, a visual's rows and columns, relationships and any filters coded in formulas. Measures always calculate under these limits; row context, by contrast, means the current row.
- FILTER
Returns just those rows of a table that meet a condition. In CALCULATE it handles conditions too complex for a Boolean filter argument, though a Boolean filter is faster whenever one will work.
Related terms
- Boolean filter expression
A true/false condition such as
'Product'[Color] = "Blue"passed as a filter to CALCULATE or CALCULATETABLE. Only one table's columns may appear in it, measures and nested CALCULATE calls are not allowed, and it overrides an existing filter on that column unless you wrap it in KEEPFILTERS. - Filter modifier functions
Rather than adding a filter, these DAX functions change the existing filter context when passed to CALCULATE or CALCULATETABLE. The group covers REMOVEFILTERS, ALL and its variants, KEEPFILTERS, USERELATIONSHIP and CROSSFILTER.
- KEEPFILTERS
Wrapping a CALCULATE or CALCULATETABLE filter argument in this DAX modifier stops it overriding filters already on those columns; instead only values satisfying both survive.
- RELATEDTABLE
For the current row, gives back the rows on the many side of a relationship. This DAX function is equivalent to CALCULATETABLE without any filter arguments.