Amounts in different currencies added together
"Amounts in different currencies added together" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) add or subtract columns whose names carry different currency markers (EUR, USD, LC…). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Convert to a single currency with the rate table before aggregating, and name the measure after the currency it returns.
What is detected
n measure(s) add or subtract columns whose names carry different currency markers (EUR, USD, LC…). Without a conversion step the total 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
Convert to a single currency with the rate table before aggregating, and name the measure after the currency it returns.
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