Dax Measure using IF statement with Values Function

tegar-budi — Tue, 31 Mar 2020 14:15:25 GMT

Hello,

I have table source like

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.

Re: Dax Measure using IF statement with Values Function

camargos88 — Sat, 04 Apr 2020 18:25:04 GMT

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

topic Re: Dax Measure using IF statement with Values Function in DAX Commands and Tips

Dax Measure using IF statement with Values Function

Re: Dax Measure using IF statement with Values Function