Forum Discussion

tegar-budi's avatar
tegar-budi
Frequent Visitor
6 years ago

Dax Measure using IF statement with Values Function

 

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.
if condition
if statement
Measures
values

1 Reply

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    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