Find the Number of Direct Report & Total Reportees under him

[mahra-in]

Hi 

I need to find out the number of direct reportees & all reportees (both direct & indirect meaning reportees of reportee) if a person is filtered or selcted

ID	Name	Manager ID	Manager Name
730810	Ravi
752875	Tancu	730810	Ravi
738072	Krishna	730810	Ravi
730287	Schmidt	730810	Ravi
755268	Daskalaki	730810	Ravi
751643	Ugochukwu Okechukwu	730810	Ravi
751772	Skjønning Andersen	730810	Ravi
755737	Pertho	730810	Ravi
731083	Nielsen	730810	Ravi
731208	Selvaraj	730810	Ravi
755650	Kumar	738072	Krishna
754081	Babuji	738072	Krishna
739592	Rajesh	738072	Krishna
738880	Arun	738072	Krishna
753018	Varun	738072	Krishna
739093	Jagadesh	738072	Krishna
738738	AG Umapathy	738880	Arun
738948	Kalyanaraman	738880	Arun
739148	Kumar	738880	Arun
755307	SOUNDARARAJ	738880	Arun

Above is my dataset

Now if I filter manager Ravi, I should get the count of Direct Reportees as 9 and total reportees as 19 separate cards & also I need the list of direct reportees names to be shown in a table and list of all reportees in another table

Similarly if I select Krishna, I should get the count of Direct Reportees as 6 and total reportees as 10 in separate cards & also I need the list of direct reportees names to be shown in a table and list of all reportees in another table

Based on filter the results shall apply. Also let me know if I can have another hierarchy table from the dataset

Can you please help me to get this result, if possible please attach the pbix file with the sample dataset

Regards

Mahes

[mahra-in]

@AlexisOlson Im nt too good in Power BI.

Could you please send me the developed pbix. It will be really helpful on my current role.

If not please explain on "a parameter table of all reportees to use as a slicer, and use PATHCONTAINS to check which paths include the slicer selected reportee"

Regards

Mahes r

[AlexisOlson · Accepted solution]

This is roughly what I had in mind.

[mahra-in]

@AlexisOlson Fantastic, Can you please attach the pbix

[AlexisOlson]

I linked to it.

[AlexisOlson]

Hint: The various PATH functions will likely be useful here. You'll probably want to set up calculated column Path = PATH ( [ID], [Manager ID] ), a parameter table of all reportees to use as a slicer, and use PATHCONTAINS to check which paths include the slicer selected reportee.