Share measure whose denominator does not remove any filter
"Share measure whose denominator does not remove any filter" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) named like a share or percentage divide a measure by CALCULATE of the same measure without ALL / ALLSELECTED / REMOVEFILTERS. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Remove the relevant filter in the denominator: CALCULATE([m], ALL(Dim[Col])) or ALLSELECTED(Dim[Col]).
What is detected
n measure(s) named like a share or percentage divide a measure by CALCULATE of the same measure without ALL / ALLSELECTED / REMOVEFILTERS. The denominator equals the numerator and the share is always 100%.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Remove the relevant filter in the denominator: CALCULATE([m], ALL(Dim[Col])) or ALLSELECTED(Dim[Col]).
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