Grouping row percentages in matrix visual

[chotu27]

Hi, all

I want to calculate each row percentage by total values as below.  

Total Employees =  It sis calculated as Count( employee ID)

Row total % =  How should i calculate to show each row percentage  like for one president total employees is 106 and exceeds expectation is 10 = 10/106*100 is the needed calculation.

Note: Here I calculated Tot employees by using Count Employee ID

[v-yulgu-msft]

Hi @chotu27,

Suppose your table structure is similar to below

Please create measures as:

Total Employee = COUNT('Employee Table'[Employee])
Row Total % =
[Total Employee]
    / CALCULATE (
        [Total Employee],
        ALLEXCEPT ( 'Employee Table', 'Employee Table'[Department] )
    )

If I have something misunderstood, please provide detailed data so that I can test for you.

Best regards,
Yuliana Gu

[chotu27]

@v-yulgu-msft

Hi you have understood in right path  but in my dataset there repeated managers for each department then how can we handle this situation. In your output you have unique manager pof M1,M2,M3.......... PLEASE CHECK BELOW IMAGE AS OUTPUT NEEDED FOR ME.

[v-yulgu-msft]

Hi @chotu27,

Have you worked it out? If so, would you please kindly mark the helpful reply as an answer or share your solution?

Regards,
Yuliana Gu

[v-yulgu-msft]

Hi @chotu27,

Measures in my original post also apply to the scenario where there existing repeated managers for each department.

Regards,
Yuliana Gu