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,