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
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))
Thanks for your reply.
So I have a master table for my projects, but I realize there is perhaps some more complexity I need to add in this for you.
In the table visual I'm looking at the average of the project metric over time for each individual project, and I have a filter to select time in the report. So the table I shared with you earlier with the metrics, each row there is an average over time for a particular project. I have built a filter so the user can select time frame. Some projects will have data for the entire time frame, while others will not have data for the entire time, so therefore I believe I can't simply divide the sum of the metric by the project count.
I have updated the tables in my OP to better explain the complexity