Overrides a relationship's filter direction for one calculation only, choosing None, Both or OneWay. This DAX filter modifier goes inside CALCULATE and leaves the model's setting unchanged elsewhere.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains CROSSFILTER in context, with comparison tables and the common traps.
Terms in this definition
- FILTER
Returns just those rows of a table that meet a condition. In CALCULATE it handles conditions too complex for a Boolean filter argument, though a Boolean filter is faster whenever one will work.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- CALCULATE
A DAX function that computes an expression after changing the filter context with filter modifiers, Boolean filters or table filters. Called with no filters, it still turns any row context into filter context, which is known as context transition.
Related terms
- Bi-directional relationship
Here filters travel from either table to the other. That helps with many-to-many bridges, but because it can hurt performance and produce ambiguous paths, Microsoft Learn suggests turning it on only when needed or using CROSSFILTER in a measure. Row-level security still filters one way unless the setting to apply security filters both ways is chosen.
- Filter modifier functions
Rather than adding a filter, these DAX functions change the existing filter context when passed to CALCULATE or CALCULATETABLE. The group covers REMOVEFILTERS, ALL and its variants, KEEPFILTERS, USERELATIONSHIP and CROSSFILTER.