Forum Discussion
Amount in total column incorrect
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 star...
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/547907
Hi,
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