Percentage denominator clears the whole model
"Percentage denominator clears the whole model" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) build a share with a denominator that calls ALL on several tables or on the whole model. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Clear only the dimension the share is computed over, with ALL(Dimension[Attribute]) or REMOVEFILTERS on that column.
What is detected
n measure(s) build a share with a denominator that calls ALL on several tables or on the whole model. The percentage is then computed against a total that ignores every slicer, including the ones the user expects to apply (period, country).
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Clear only the dimension the share is computed over, with ALL(Dimension[Attribute]) or REMOVEFILTERS on that column.
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