How to Get a count of Direct and Indirect Reports

[Anonymous]

Hello,

I have start to build my table based on the information found at the link below.

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

So using the new Hierarchy Slicer Visualization it give us what we see below

So from the first top level manager (FName1 Name1) we see that direct under him, we have Name11, Name13, Name15 and Name17. So there is 4 persons who directly report to Name1.  Then again, we see that under Name13 we have Name103 and under Name15 we have Name105. Same thing under Name17, we have Name102 and Name104. Therefore, we have 4 peoples who indirectly report to Name1.

Keeping the same logic, we have one person who report to name13 which is Name103.  So 1 person directly report to Name13,

1 directly report to Name15 (Name105) and 2 persons directly report to Name17 (Name102 and Name104).

We could do the same exercise for the two other top managers (Name2 and Name3).

So if we add the direct employee count and indect employee count to the table below, 

we should see for Name1 4 under direct report and 4 under indirect report.

Also 0 under direct report and 0 under indirect report for Name11, 1 direct report and 0 indirect report for Name13 and so On.

So how do we calculate the number of persons who directly report to a manager and indirectly report to a manager, considering that if you are a manage at level1 only person at level2 directly report to you and the other level indirectly report to you.

Same thing for a manager at level2, only the peoples at level3 directly report to you and the persons at the other level are indirectly reporting to you and so on.

On top of that does the hierarchy slicer can show value?  I have tried to put any measure int the value windows but nothing seems to work.  I might need to use a matrix instead.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Based on my research, it is not supported yet currently. We can only use matrix to work around.

[Anonymous]

That what I thought.

Thank you very much for your time