ALLEXCEPT applied to a fact table
"ALLEXCEPT applied to a fact table" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) call ALLEXCEPT on a fact table. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Apply ALLEXCEPT to the dimension that carries the attribute, or use REMOVEFILTERS on the specific columns you mean to clear.
What is detected
n expression(s) call ALLEXCEPT on a fact table. Every column of the fact is cleared except the ones listed, so filters coming from dimensions are silently dropped and the result is wider than the author expects.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Apply ALLEXCEPT to the dimension that carries the attribute, or use REMOVEFILTERS on the specific columns you mean to clear.
Reference
SQLBI: ALLEXCEPT and the expanded table
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