DAXMaintainabilityLowHygiene · not counted in the score
Chain of IF where SWITCH reads better
"Chain of IF where SWITCH reads better" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n expression(s) chain four or more IF statements on the same column. It is a hygiene note: provable, worth fixing, but it never moves the health score. Rewrite as SWITCH on the column, or move the mapping into a table.
What is detected
n expression(s) chain four or more IF statements on the same column. SWITCH expresses the same mapping in a form the next reader can scan.
Why it matters
Hygiene and conventions. Reported in its own section and never deducted from the health score.
How to fix it
Rewrite as SWITCH on the column, or move the mapping into a 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