Count percentage of employees handled

[ovetteabejuela]

Hi Community,

I know this is simple but can't get it to work, wonder what I'm missing.

How do I extract this information:

Handled Employees: is just the count of instance of the manager's name

% of Handled Employees = Handled Employees: over total population

Manager	Handled Employees	% of Handled Employees
Recla, Kathlyn	6	22.22%
Strout, Walton	7	25.93%
Bonton, Carter	3	11.11%
Rena, Bradley	5	18.52%
Launt, Eulah	6	22.22%

Using this sample database (all names are fictitious, they are randomly generated):

Employee	Manager	Second Line Manager
Mierow, Arla	Recla, Kathlyn	Newtown, Rebecca
Greff, Roscoe	Recla, Kathlyn	Newtown, Rebecca
Casumpang, Deangelo	Recla, Kathlyn	Newtown, Rebecca
Czartoryski, Erlene	Recla, Kathlyn	Newtown, Rebecca
Carota, Mario	Recla, Kathlyn	Newtown, Rebecca
Blemel, Maxima	Recla, Kathlyn	Newtown, Rebecca
Whittum, Lezlie	Strout, Walton	Newtown, Rebecca
Blackson, Dorian	Strout, Walton	Newtown, Rebecca
Hilyard, Kent	Bonton, Carter	Newtown, Rebecca
Giacobbe, Tatiana	Bonton, Carter	Newtown, Rebecca
Flaugher, Whitney	Strout, Walton	Newtown, Rebecca
Varano, Foster	Strout, Walton	Newtown, Rebecca
Willens, Meggan	Strout, Walton	Newtown, Rebecca
Kaltved, Luann	Strout, Walton	Newtown, Rebecca
Mckitrick, Clayton	Strout, Walton	Newtown, Rebecca
Wigboldy, Lashunda	Rena, Bradley	Hardwood, Felix
Garnand, Latrisha	Rena, Bradley	Hardwood, Felix
Hebeisen, Willian	Rena, Bradley	Hardwood, Felix
Nagelschmidt, Margot	Rena, Bradley	Hardwood, Felix
Clausen, Lavonna	Rena, Bradley	Hardwood, Felix
Steik, Cory	Launt, Eulah	Hardwood, Felix
Rockholt, Adelina	Launt, Eulah	Hardwood, Felix
Rissman, Gonzalo	Launt, Eulah	Hardwood, Felix
Stumbo, Albert	Launt, Eulah	Hardwood, Felix
Brague, Dalene	Launt, Eulah	Hardwood, Felix
Pullus, Mignon	Launt, Eulah	Hardwood, Felix
Erice, Ima	Bonton, Carter	Newtown, Rebecca

[Vvelarde · Accepted solution]

@ovetteabejuela

Hi, review this:

[Vvelarde · Accepted solution]

@ovetteabejuela

Hi, review this:

[Sean · Accepted solution]

 Here are the Measures - this way you can control the names!

Handled Employees = DISTINCTCOUNT ( 'Table'[Employee] )

% of Handled Employees =
DIVIDE (
    [Handled Employees],
    CALCULATE ( [Handled Employees], ALLSELECTED ( 'Table' ) ),
    0
)

[ovetteabejuela]

The question was answered but I left off some details so I still have a followup question

How do I ignore the current context. For example if I do a drill down the percentage will not be the against GRAND TOTAL but instead against the total of the current context.

what if I do a drill-down graph from Second Line Manager to Manager(First Line) to Employee, I'm not seeing percentage out of the grand total but on for the total of the current filter.

[ovetteabejuela]

Ok I think I got the answer myself... I just used the ALL keywork to unfilter everything this way even if I do filters the grand total stays the same, I don't know why they called it grand total but it reacts on filters, must be called sub-total then. Anyway I got it to work so I'm good for now. thanks again for your inputs guys, really appreciate it.