CALCULATETABLE

Syntax

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

Tutorial with example

In todays video we are going to cover the DAX function CALCULATETABLE.

CALCULATETABLE allows you to create virtual tables that you can then filter using multiple conditions and use that table to make further calculations.

Download example file:

Download Power BI file: here.

Additional resources:

Calculated tables in Power BI allow you to create subsets of your data and they are also useful for checking your DAX measures, check the video to learn how.

Remarks

The CALCULATETABLE function changes the context in which the data is filtered, and evaluates the expression in the new context that you specify. For each column used in a filter argument, any existing filters on that column are removed, and the filter used in the filter argument is applied instead.

This function is a synonym for the RELATEDTABLE function.