Span of Control

[PrachiD]

Hello All,
I want to calculate the average span of control.
if 1 has a two child that are 1 and 2 and 1 and 2 again have the subchild that are 1 ,1 as show in fig.
I want to calculate the span of control for each parent node.
In the above example the span of control is 4 for the 1st parent node. Likewise i have to calculate for root node as well as for there parent node also.
So plz help me to get the required result

[v-shex-msft]

Hi @PrachiD,

Is there are columns which similar as 'parent node' to description these relationships? If this is a case, you can try to use path function to analysis the relationship.

You can refer to below link to know more about this:

Parent-Child Hierarchies

If above not help, please share some detail contents to help us clarify your scenario.

Regards,

XIaoxin Sheng

[PrachiD · Accepted solution]

I have crunched the data. 
Because the given data was not in the heirarchy format.
i made it in heirarchya and got the result
Thank you all for your help

[Greg_Deckler]

Can you provide some sample data? This looks like simple counting. You could get there with my Groups and Super Groups article:

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[PrachiD]

No I cannot share the data...numbers in the rectangle aree nothing but ID of employee

[Greg_Deckler]

Can you share make believe data that is in the same format as your real data? Like, is it:

EmployeeID,ManagerID

4,1

5,1

6,4

7,5

So 4 and 5 report to 1, 6 reports to 4 and 7 reports to 5?

[PrachiD]

yes exactly