Press "Enter" to skip to content

Specifying Multiple Filter Conditions in DAX with CALCULATE

Marco Russo and Alberto Ferrari take a look at some new syntax:

DAX now supports expressions where multiple columns belonging to the same table are part of the predicate expression in a CALCULATE filter argument.

Thus, the following Big Sales Amount Overrides Filter measure is now a valid DAX expression:

This is new as of March 2021, so check out the demo-filled example.