DAX(Switch and calculate)

Hi, I have a problem using DAX/SWITCH.

My DAX is as below:
AR_JPY(Simul) = SWITCH(CALCULATE(MAX(‘Main’[Currency])),
“USD”,CALCULATE(SUM(‘Main’[AR]))*USD[USD の値],
CALCULATE(SUM(Main[AR_JPY])))

I’m using parameter for USD for currency exchange simulation purpose.
Only for USD, I use parameter but for other currency I want to keep original AR_JPY values.
And for “_Total”, I would like to calculate total amount properly.

The problem is I don’t know what to write for “_Total”.

If you could fill calculate_DAX below for me, I really appreciate it.

AR_JPY(Simul) = SWITCH(CALCULATE(MAX(‘Main’[Currency])),
“USD”,CALCULATE(SUM(‘Main’[AR]))*USD[USD の値],
“_Total”, (calculate_DAX) ,
CALCULATE(SUM(Main[AR_JPY])))

Regards,

I solved this issue by myself. I will share with you later. Thanks.

1 Like