CROSSFILTER

Syntax

CROSSFILTER(<columnName1>, <columnName2>, <direction>)  

Tutorial with example

In this video we will go through the DAX function CROSSFILTER.

Related material:

How to void Bidirectional relationships:

Download example file:

To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #121

Remarks

• In the case of a 1:1 relationship, there is no difference between the one and both direction.
• CROSSFILTER can only be used in functions that take a filter as an argument, for example: CALCULATE, CALCULATETABLE, CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR, OPENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR, TOTALMTD, TOTALQTD and TOTALYTD functions.
• CROSSFILTER uses existing relationships in the model, identifying relationships by their ending point columns.
• In CROSSFILTER, the cross-filtering setting of a relationship is not important; that is, whether the relationship is set to filter one, or both directions in the model does not affect the usage of the function. CROSSFILTER will override any existing cross-filtering setting.
• An error is returned if any of the columns named as an argument is not part of a relationship or the arguments belong to different relationships.
• If CALCULATE expressions are nested, and more than one CALCULATE expression contains a CROSSFILTER function, then the innermost CROSSFILTER is the one that prevails in case of a conflict or ambiguity.