Total is wrong when multiplying amount with currency value

[jaco1951]

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

[v-yuezhe-msft]

@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,
Lydia

[jaco1951]

Hi 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=...

All values in same currency:

https://www.dropbox.com/s/3g9a416dzsb2mea/Data%20for%20currency%20and%20Sum%20Total%20issue%20Single...

Hope this makes it understandable. 

Thank you 😉

[parry2k]

You have to use SUMX for your calculation.

[jaco1951]

Thanks, that was a good suggestion, but it doesn't solve the problem. Still not correct sum.