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 ChampionAnonymous Usually this is the opposite problem. I would modify the measure to this (below). Then, modify your RETURN statement to be your __FTEs and __Capacity VAR's to confirm the numbers being returned in the Total row. My guess is that the problem will come down to how you are calculating the capacity.
Measure FTE % to Reg'd No.s =
VAR __FTEs = SUM(FTE[FTE])
VAR __Capacity = MIN(FTE[data.siteCapacity])
VAR __Result = DIVIDE( __FTEs, __Capacity )
RETURN
__Result