Forum Discussion
Exclude Blank Measure Values From Average Calculation
Hello, I am looking for some direction on excluding blank measure values from my average cost per square foot calculation. I am not using AVERAGE, because I have to do the cost per sqft calculation ...
Please recall my original post:
_mAvg Cost Per SQFT per Product =
CALCULATE(DIVIDE(DIVIDE('CostPerSqft'[_mCost Per SQFT],'CostPerSqft'[_mDistinctCount YYYMM], 0), DISTINCTCOUNT('CostPerSqft'[Product]), 0))
Unfortunately, your solution does not take into account the separate Products.
It does. Please recheck.
Thanks for your efforts on this.