I'm trying to get the Matrix table to calculate percentages based on a subtotal. In this case, I'd like the highlight below to calculate 4 divided by 19 for a total of 21.05%. Instead, it is looking at the Grant Total and returning a much lower answer (13%). I've tried multple things but have been unsuccessful. Please help.
1 ACCEPTED SOLUTION
Hi @Anonymous,
Great to hear it works!
You can change the formatting of the measure to Percentage under Modeling tab like below. 
Regards
Helpful resources
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
