Forum Discussion
eduardoa
Advocate I
Advocate IManaging a wrong total result in a visual
Hello, In the table, we have multiple currencies with corresponding rates. The total result should simply be the multiplication of [Amount] * [LastRate]. While the total displayed in Excel is corr...
Hi Here is your result
Hope images are self explainatory.
Rupak_bi
Super User
Super UserHi eduardoa ,
The simplest way to achieve this is to create a calculated column and then take sum in the matrix. To do it in DAX use below sintex.
Corrected total =
Var tot_amt = calculate(sum( amount), all(table))
Return
Sumx(table, amount*last rate/tot_amt)*tot_amt
This will work. If fails, Let me know. I will create table with the image you shared and explain.
