CROSSFILTER set to both directions in a measure
"CROSSFILTER set to both directions in a measure" is one of the modeling checks Auditabi runs on a Power BI semantic model. n measure(s) open bidirectional filtering with CROSSFILTER. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Keep it, and document why; make sure the ambiguity it creates is not visible in totals.
What is detected
n measure(s) open bidirectional filtering with CROSSFILTER. It is the right tool when a single measure needs it, but it makes the filter path of that measure different from every other measure in the model.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Keep it, and document why; make sure the ambiguity it creates is not visible in totals.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together