I work in a professional services organization and am trying to build a PBI report that shows associates who have available capacity on any given week based on their targets and schedules. I have the report working all the way up until the grand totals all the way on the right. I know I can turn off this value but it actually would be really helpful have if we can make this work.
Because I’m having to return the MIN at the week level, the total column is not correct. I was able to get the weekly totals to add up using SUMMARIZE, but have not been able to solve for the Grand Total on the right.
I have attached an example PBIX file hoping this might help with troubleshooting.
Thanks for any help,
Capacity Sample Data.pbix (788.8 KB)