Dax Measure using IF statement with Values Function

[tegar-budi]

Hello,

I have table source like

Table

I want to change value to USD Rate using a measure for my report.
I can use a calculated column but i have 120 val column, it will make my report load slow if use calculated column. So I prefer using a measure
but my dax not work properly.

My Dax : 

M_Val 1 = IF(Values('Table'[Cd_Currency])="IDR";

SUM('Table'[Val_1])/VALUES('Table'[Now_Currency]);

SUM('Table'[Val_2]))

it show : A Table with multiple values was suplied where a single value was expected

I don't mind if I have to make 120 measure val. I think it will be faster than the 120 val column

any assistance will be appreciated. thanks.

[camargos88]

Hi @tegar-budi ,

I used Power Query to unpivot all the values colums and create another custom column to convert the values IDR

You can check it on this file as an example: Download PBIX 

Ricardo