Forum Discussion
Matrix table Total Row shows incorrect total value for Percent column
Anonymous I think HotChilli is correct, seems like you need to get the correct total for your capacity. You can do that following this guidance (below). Alternatively perhaps change your MIN to SUM for getting your capacity.
First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Community Champion352 / 52 as a percentage = 677 so it's all correct but not what you wanted. There's enough documented posts on measure totals out there so you can go off and research those for more info.
The solution is usually to iterate over each line of the table and add the measure calculated for each line. I can't tell from the picture what the right granularity would be.
Is that enough to start you on the right path?
Ah! Couldn't see the woods for the trees! Thanks for this, totally understand where I was going wrong now.