Percentage of a subcategory in Matrix with two column levels

[Oksie]

Hello!

I have a Matrix with 2 column values drilled down and I need the percentages to add up to 100% within the first category. So, in this table, all of the solution times within the 'Urgent' priority should add to 100, like in the table below.

I tried to find the solution on my own, but everything I could find dealt with just one column value, not two. 

Is this achievable in Power BI?

Thank you very much!

(edit: i can't fix the table for some reason but the 'Normal' tag is supposed to be to the right)

Priority	Urgent	Normal
Solution time	<5m	>5m	<5m	<10m	>10m
Date
1/07/2023	10%	90%	10%	20%	70%
2/07/2023
3/07/2023

[Sahir_Maharaj]

Hello @Oksie,

Can you please try this:

1. Create a Measure for Total Percentage

Total Percentage = SUM('YourTable'[Percentage])

2. Create a Measure for Percentage of Total

Percentage of Total = DIVIDE([Total Percentage], CALCULATE([Total Percentage], ALL('YourTable'[Solution Time], 'YourTable'[Priority])))

3. Apply conditional formatting to the "Percentage of Total" measure as necessary.

Should you require further assistance, please do not hesitate to reach out to me.