How to get a percentage column in matrix table

[LiamReidy]

Hi Community,

I want have a matrix which shows the number of people that have completed training. It is broken down by division, sub division, practice, and gives a headcount for the practice. I also want to show the percentage of people who have completed training in each practice, sub division and vision.

When I add the % completion to my matrix, the practices are correct but the division and subdivision % are a sum of the practice %, which is inaccurate. The % for division should be grand total completed / grand total headcount. The % completed for sub division should be sub total completed / sub total headcount. See right hand table Figure 2.

Figure 1 shows my data from excel:

Figure 1:

Figure 2:

[v-eachen-msft]

Hi @LiamReidy ,

You could refer to the following measure:

Measure =
IF (
    ISINSCOPE ( 'Table'[Practice] ),
    SELECTEDVALUE ( 'Table'[Percentage] ),
    DIVIDE ( SUM ( 'Table'[Completed] ), SUM ( 'Table'[headcount] ) )
)

[FrankAT · Accepted solution]

Hi @LiamReidy,

here is my solution (see figure):

Regards FrankAT

[LiamReidy]

Thank you @FrankAT ! I seem to be 90% of the way there. I cant seem to find where to change it from a decimal to a %. Can you let me know please then will accept as a solution. (i will accept it if i find it before another reply )

Thanks,

Liam

[FrankAT]

Hi, @LiamReidy,

select the measure, open tab Measure tools and change the formatting (see figure):

Regards FrankAT