Tag Archives: Dashboard

Cheat CodeSelected = 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 PowerBIalways 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!