DAX function

CALCULATETABLE — DAX function reference

Like CALCULATE, returns a table.

Syntax

dax

CALCULATETABLE(<table>, <filter1>, <filter2>, …)

dax

CALCULATETABLE(Sales, Sales[Year] = 2026)

→ A table

dax

COUNTROWS(CALCULATETABLE(Sales, Sales[Region] = "West", ALL('Date')))

→ West-region row count regardless of the current date filter

Returns a filtered table you can feed into another function, unlike CALCULATE which returns a scalar.

dax

CALCULATETABLE(VALUES(Product[Category]), Sales[Amount] > 1000)

→ Categories that had at least one large sale

CALCULATETABLE is to table expressions what CALCULATE is to scalars — the same filter-argument override, KEEPFILTERS, and context-transition rules apply.
Because it returns a table, it's typically nested inside COUNTROWS, iterators, or a table-valued measure rather than used as a measure body directly.

From Filter context