Forum Discussion
Dealing with missing rows in underlying data, and adding 0 values
To put it simply our database is calculating 40 metrics for thousands of projects on a daily basis. Each row in the database has project ID, metric type, value, and date. To save on performance our d...
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
You need a master table for your projects
After that it is trivial. In your visual select the project ID from the master table and the metric from the results table. Show items wth no data.
And the measure will be
Measure = divide(sum(Results[Metric]),COUNTROWS(Projects))