Please help with a simple metric. In the table, the sum of the metrics shows correctly. On the Waterfall and similar charts, the sum is completely different and it is the same metric. Contribution wrong waterfall.pbix (112.3 KB)

@Harris This is a classic “Totals Don’t Add Up” problem. When you are seeing the correct value at the row, but the incorrect value at the total, it has to do with the fact the aggregation is occurring before the critical multiplication, or whatever else you are attempting to evaluate. This is bec…

Enterprise DNA Forum

Wrong sum on waterfall visualization

DAX DAX Calculations

Harris January 22, 2022, 12:12am 2