Ratio column summed instead of recomputed
"Ratio column summed instead of recomputed" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) SUM a column whose name says it is a rate, a percentage or a ratio. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Recompute the ratio at the level of the visual with DIVIDE over the two underlying totals.
What is detected
n measure(s) SUM a column whose name says it is a rate, a percentage or a ratio. Summing ratios is meaningless: the total of the visual is the sum of percentages, not the overall percentage.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Recompute the ratio at the level of the visual with DIVIDE over the two underlying totals.
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