Cheat Sheets/Power BI/CROSSFILTER
DAX function

CROSSFILTERDAX function reference

Set cross-filter direction.

Syntax

dax
CALCULATE(<expression>, CROSSFILTER(<columnName1>, <columnName2>, <direction>))

Examples

dax
CALCULATE([Sales], CROSSFILTER(Sales[CustID], Customer[CustID], BOTH))
A number
dax
CALCULATE(DISTINCTCOUNT(Customer[CustomerID]), CROSSFILTER(Sales[CustID], Customer[CustID], BOTH))
Distinct customers filtered by a Product-side selection, via bidirectional filtering just for this measure
dax
CALCULATE(SUM(Sales[Amount]), CROSSFILTER(Sales[CustID], Customer[CustID], NONE))
Disables the relationship entirely for this calculation

Common mistakes & gotchas

Related DAX functions

From Relationships

← Back to the Power BI (DAX) cheat sheet