Formula – My IT Cheat Code

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”