Percentages and amounts summed together
"Percentages and amounts summed together" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) add together values that are ratios (measures named %) and values that are amounts (measures named amount, sales, value). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Sum only homogeneous quantities; if a waterfall needs both, return the row value for the selected category instead of the total.
What is detected
n measure(s) add together values that are ratios (measures named %) and values that are amounts (measures named amount, sales, value). The sum has no unit.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Sum only homogeneous quantities; if a waterfall needs both, return the row value for the selected category instead of the total.
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
- Measure with an empty expression