Count in hierarchy

[Anonymous]

I have a hierarchy in my Employee table as follow: 

It means that each teamLeader has many team members. 

How can I dynamically count the number of memebers per team leader??

[Greg_Deckler]

@Anonymous - So are you saying this is solved? Or are you still looking for a measure to do this? The solution will depend upon your data if you can share sample data. Generally involves using the PATH set of functions, like PATHLENGTH, etc.

[Anonymous · Accepted solution]

following the suggestions in this post :
https://community.powerbi.com/t5/Desktop/DAX-SQL-window-function-equivalent/td-p/146128

I made a calculated column like this : 

MemebrsCount =

COUNTAX (

FILTER ( Employee; EARLIER (Employee[TeamLeaderName]) = Employee[TeamLeaderName] );

Employee[FullName]

)

and it counts me the numbers of team members per team leader

[amitchandak]

@Anonymous , have created hierarchy like this

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

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.