The CROSSFILTER function

Similar to the USERELATIONSHIP() function that can invoke an inactive relationship for a specific DAX measure, the CROSSFILTER() function can be used to implement a specific cross-filtering behavior (single, bidirectional, none) for a specific measure. The cross-filtering behavior specified in the measure overrides the default cross-filtering behavior defined for the relationship.

In the following report visual, an Employee Count measure only references the Employee dimension table and therefore is not impacted by the filter selections of the Sales Territory Country slicer due to the single direction relationship between Employee and Reseller Sales:

Bidirectional cross-filtering via the DAX CROSSFILTER function ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.