Forum Discussion
Dealing with missing rows in underlying data, and adding 0 values
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Have you tried this approach?
Project Avg = AVERAGEX(VALUES(Table[Project ID]), [Metric])
If your metric measure returns zero, it would be included in the average.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
I have tried that approach, and it works on the project row level. But it doesn't produce the desired result for the totals row (where we want an average of averages)