All checks
DAXDAX QualityMedium

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.

Audit a model

More DAX checks