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.
Was this helpful?
Hi Ruth, i am trying to download the pbix file but it’s not availeble.
Hi,
It is available in the download center.
/Ruth
A great explanation thank you. I am unable to download the file, please can you share another way?
Hi,
I have created a download center where you can get all my pbi files in one place. Here it is:
https://curbal.com/donwload-center
/Ruth
Hola Ruth, el video de arriba no tiene nada que ver con crossfiltering si no con como hacer measures rapidamente…
Gracias Antonio!
Corregido…
/Ruth 🙂