Percentage label built without ×100
"Percentage label built without ×100" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) format a ratio with a non-percent format and append "%" as text (FORMAT(x, "0.00") & "%"). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Use FORMAT(x, "0.00%") (which scales by 100) or a percentage format string on the numeric measure.
What is detected
n measure(s) format a ratio with a non-percent format and append "%" as text (FORMAT(x, "0.00") & "%"). A ratio of 0.15 is shown as "0.15%".
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Use FORMAT(x, "0.00%") (which scales by 100) or a percentage format string on the numeric measure.
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
- Percentages and amounts summed together
- Measure with an empty expression