IF returning a number on one branch and text on the other
"IF returning a number on one branch and text on the other" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) return a number in one branch of IF or SWITCH and a text literal in another. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Return one type.
What is detected
n measure(s) return a number in one branch of IF or SWITCH and a text literal in another. The measure becomes a variant: it cannot be summed, sorted or conditionally formatted reliably.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Return one type. Put the message in a separate measure used as a tooltip or a card, not in the value itself.
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