Measure returning text in one branch and a number in another
"Measure returning text in one branch and a number in another" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) return a string (a warning such as "Select one year") on one path and a number on 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 BLANK() on the guard path and show the warning from a dedicated text measure.
What is detected
n measure(s) return a string (a warning such as "Select one year") on one path and a number on another. The measure becomes a variant: sorting, conditional formatting, totals and any dependent measure break when the text path is hit.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Return BLANK() on the guard path and show the warning from a dedicated text measure.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.