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 ...
curtismob , This formula seems fine, remove 0 from first divide and check
CALCULATE(DIVIDE(DIVIDE([_mCost Per SQFT],[_mDistinctCount YYYMM]), DISTINCTCOUNT('CostPerSqft'[Product]), 0))
amitchandak, thank you for the response. Unforrtunately, that did not resolve my issue.