Forum Discussion
Exclude Blank Measure Values From Average Calculation
I apologize for the simplified data. Below are links to my version with updated data and your version with the updated data.
Ashish version:
https://drive.google.com/file/d/1CkvrqfaEoJv-ac-3cE4I8y8ehs-P-EvB/view?usp=sharing
Curtis version:
https://drive.google.com/file/d/1b_WtRzddQylXohYGQV3aM8EEdpxsI4Yz/view?usp=sharing
Hi,
I receive an access desnied message when i click on those links. On any dataset that you share, please show the expected result.
Hi,
In my version of the file, the average is 25.28. That seems correct. Drag the other 2 measures to the visual and export the data to MS Excel. Add the Total cost and Total Area column and divide the 2. The result will be 25.28.
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.