• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Data Stories
    • Power BI Stories
    • 1 dataset, 100 matplotlib visualizations
  • Learning Portal
    • Download Center
    • 25 Days Challenge
    • DAX Glossary
    • Power BI
    • Power BI by Topic
    • Python
    • 1 dataset, 100 matplotlib visualizations
  • Courses
    • Power BI Mini Master Class 1: Using a REST API as a data source
    • Power BI Master Class 1: COVID Tracker
    • Introduction to Power BI – FREE Online course
    • M Language + Power Query Course Bundle
    • Power Query Online Training [updated 2022]
    • M Language Online Course: The unofficial and Practical Reference Guide [updated 2025]
    • My Courses
  • Shop
    • Courses
    • Master Classes
    • Template Apps
    • JSON Themes
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Search
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / CROSSFILTER

CROSSFILTER

posted on March 25, 2018

« Back to Glossary Index

Syntax

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

Tutorial with example

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

DAX Fridays! #44: CROSSFILTER

Related material:

How to void Bidirectional relationships:

DAX Fridays! #121: Avoid bidirectional relationships (brute force method)

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?
« Back to Index

Reader Interactions

Comments

  1. arnoh

    December 31, 2018 at 8:09 am

    Hi Ruth, i am trying to download the pbix file but it’s not availeble.

    Reply
    • Ruth Pozuelo Martinez

      December 31, 2018 at 4:26 pm

      Hi,
      It is available in the download center.
      /Ruth

      Reply
  2. J

    October 15, 2018 at 2:20 pm

    A great explanation thank you. I am unable to download the file, please can you share another way?

    Reply
    • Ruth Pozuelo Martinez

      October 15, 2018 at 5:54 pm

      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

      Reply
  3. Antonio Rasco

    April 1, 2018 at 9:10 am

    Hola Ruth, el video de arriba no tiene nada que ver con crossfiltering si no con como hacer measures rapidamente…

    Reply
    • Ruth Pozuelo Martinez

      May 8, 2018 at 10:55 am

      Gracias Antonio!
      Corregido…
      /Ruth 🙂

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer CTA

Join our community of +50,000 professionals

Become a Member

Subscribe to YouTube

About me:

Curbal AB
Badhusgatan 7B
722 15 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2025 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In