Arithmetic or comparison on a measure that returns text
"Arithmetic or comparison on a measure that returns text" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) multiply, add, divide or compare a measure whose result is text (FORMAT, string literal, concatenation). It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Keep the numeric measure numeric (format string / dynamic format string) and build a separate label measure for text; reference the numeric one in calculations.
What is detected
n measure(s) multiply, add, divide or compare a measure whose result is text (FORMAT, string literal, concatenation). The engine cannot convert "12.5%" or a warning message to a number: the visual shows an error or a blank.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Keep the numeric measure numeric (format string / dynamic format string) and build a separate label measure for text; reference the numeric one in calculations.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.