Forum Discussion
Total is wrong when multiplying amount with currency value
Hi all
I have a formula that works on row level, but the total is incorrect.
outgoing_total_USD = [outgoing_total] * MAX(factTable[inverse_CurrencyValue])
Does anyone know how to solve this?
Thanks
Br
Espen
4 Replies
You have to use SUMX for your calculation.
Thanks, that was a good suggestion, but it doesn't solve the problem. Still not correct sum.
jaco1951,
Please refer to the following similar blog to modify your DAX. If you still get wrong total, please share dummy data of your table so that we can provide op appropriate DAX.
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Regards,
LydiaHi Lydia
I have studied the example back and forth, and I am not able to recreate it. In my case the total works fine when the currency is the same for the seleceted group. Once I have two currencies, it seems to ignore the calculation of NOKUSD and just show the total as it would be in local currencies, not calculated to USD.
https://www.dropbox.com/s/xk7o5ga9r9yajwe/Data%20for%20currency%20and%20Sum%20Total%20issue.xlsx?dl=0All values in same currency:
Hope this makes it understandable.
Thank you ;-)
