PowerBI – Switch Measures Dynamically

Cheat Code
Selected = if(
HASONEVALUE(‘Currency Switcher'[Currency]),
SWITCH(
VALUES(‘Currency Switcher'[Currency]),
“Local”,sum(fact_order[CostLocalCurrency]),
“USD”,sum(fact_order[CostUSD])))

Simple!
Enuf say…

Everyday I’m shufflin’ with PowerBI
always new things to learn…

Too many copy of dashboard/report just to switch couple of measures. I’m lazy and I dont like repetitive task. KISS Yo! Keep It Simple and Stupid.

Have Fun!