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!
Tag Archives: PowerBI
PowerBI – Count Dimension by other dimension linked by fact
Cheat CodeCountTargetRows = CALCULATE( DISTINCTCOUNT(dim_TargetDimension[TheColumnName]), FILTER(dim_middle_man, CALCULATE(sum(FT_Transaction[Cost])>0))) Love-Hate relationship with PowerBI! I love the product as it’s super powerful BI tool, not to mention CHEAP (it’s free as matter of fact – PowerBI Desktop). It can do magic and wonder. Today I was asked how to create calculation for count of dimension rows but it’sContinue reading “PowerBI – Count Dimension by other dimension linked by fact”
My IT Cheat Code 