CALCULATE filter overrides the slicer without KEEPFILTERS
"CALCULATE filter overrides the slicer without KEEPFILTERS" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) pass a column predicate to CALCULATE on a column that is also used as a slicer attribute. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Wrap the predicate in KEEPFILTERS when you mean to intersect with the user's selection, and leave it bare only when you really mean to override.
What is detected
n measure(s) pass a column predicate to CALCULATE on a column that is also used as a slicer attribute. The predicate replaces the user's selection instead of narrowing it, so the visual shows a value the slicer does not describe.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Wrap the predicate in KEEPFILTERS when you mean to intersect with the user's selection, and leave it bare only when you really mean to override.
Reference
SQLBI: Using KEEPFILTERS in DAX
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