Forum Discussion
Selected Value and IF Else statement issue - Dynamic Calculations
Hi I have a below scenarion, I'm able to achive it but where i need to create multiple DAXs for each "Global/Region" values and its each "market" values as below example. I have two global/r...
Hi amitchandak
Sorry the below is also not working
how to handle the else part -
Finaltest = SWITCH(SELECTEDVALUE(Countrys[Region/Global]),
"Asia", [Asia-Total],
"Asia", [Asia-Total],
"Africa",[Africa-Total],
"sum(Countrys[Actual]))
Still working, but not working on else part
Thanks for your reponse.