Forum Discussion
Amount in total column incorrect
Table
I've created a table in which the last column comes from a Quick measure. It multiplies the value in the start column by the value in the exchange colomn. For some reason the total For the start column is correct but the total for the Start in ANG is incorrect. I cannot figure out how to solve this
3 Replies
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Hi,
I do understand now how the total shown is calculated. Thank you that was helpfull.
I've been trying to get the sum of this column with the hasonefilter function (to be honest i do not completely understand that function so using it is a bit difficult), but I cannot seem to make it work.
This is my formula now:
Start in ANG =SUM('Currency converter'[Exchange]) * [Totaal start]I did try a more advance way of recalculating amounts based on conversion rates but that was to advance for me.I am really new to PowerBI so I'm still struggling a bit with the basics.kind regards, Lisa
For totals in measure, the logic is different to columns. 65,705.87 * (1+1.95+1.78) is the logic for a measure.
The two short blogs explain the total issue very clear.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Best,
Paul
