Showing 100% of total each column

[burak]

Hello,

My dataset looks like this:

I am creating a Matrix to see % of totals. But, the problem is to not be able to calculate 100% for each column. In power BI, it looks this:

But, I would like to see the calculation like this:

[KGrice · Accepted solution]

Hi @burak. You can get the desired result with the three measures below. Names can be whatever makes sense.

Sum of Units = SUM(Table1[Unit Taken])

Sum of Units All College = CALCULATE([Sum of Units], ALL(Table1[College])) 

Percent of All = DIVIDE([Sum of Units], [Sum of Units All College]) 

You could also do it all in one measure, but based on your other posts, it would be good to keep these as building blocks that you can use in other places.

[burak]

Thank you for your help. It works, but I have a little concern.

One of the colleges is filtered out in my PBI and this formula still does not show 100%. Although the table does not show the filtered college, it keeps the percentage on the background. As a result, I am getting total percentages in each column like 99%.

Is there any way to correct the formula?

[KGrice]

@burak. Change the ALL(Table1[College]) to ALLSELECTED(Table1[College]). That will count the colleges not filtered out by other things.

[burak]

Great! Thank you very much.