Share denominator clears a fact-table column instead of the dimension
"Share denominator clears a fact-table column instead of the dimension" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n share measure(s) use ALL / ALLSELECTED on a column of the fact table while the same attribute exists on a dimension. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Clear the filter on the dimension column that the report actually filters: ALL(Dim[Attribute]) or ALLSELECTED(Dim[Attribute]).
What is detected
n share measure(s) use ALL / ALLSELECTED on a column of the fact table while the same attribute exists on a dimension. Slicers filter the dimension, so the denominator stays filtered and the share is 100 %.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Clear the filter on the dimension column that the report actually filters: ALL(Dim[Attribute]) or ALLSELECTED(Dim[Attribute]).
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.