SWITCH without a default branch
"SWITCH without a default branch" is one of the reliability checks Auditabi runs on a Power BI semantic model. n expression(s) use SWITCH with an even number of arguments, so no default result is given. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Add a default result, even if it is an explicit "Unknown" or BLANK(), so the intent is documented.
What is detected
n expression(s) use SWITCH with an even number of arguments, so no default result is given. Any value not listed returns BLANK, and a new category in the source appears as an empty cell.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Add a default result, even if it is an explicit "Unknown" or BLANK(), so the intent is documented.
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