Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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??
Solved! Go to 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 :
@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.
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 :
@Anonymous , have created hierarchy like this
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |