Forum Discussion
Microsoft EmployeeParent child hierarchy count children
Super UserPlease provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Microsoft EmployeeHi- Sorry for the delay. i am attaching the sample data and my issue below. please help me with a solution.
i have org employee hierarchy info like this
| index | reporting | Name |
| 1 | vamsi | |
| 2 | srikant | vamsi |
| 3 | mahesh | vamsi |
| 4 | mithun | vamsi |
| 5 | srijit | srikant |
| 6 | shankar | srikant |
| 7 | patak | mahesh |
| 8 | srikumar | mahesh |
| 9 | prerna | mithun |
| 10 | nagaraja | mithun |
| 11 | abhishek | mithun |
| 12 | sahibi | prerna |
| 13 | atul | abhishek |
| 14 | manesh | srikumar |
| 15 | mayur | patak |
and i have another data with the index who are particular users of some app. lets say below are users
| index |
| 1 |
| 10 |
| 12 |
| 3 |
| 6 |
| 7 |
| 8 |
| 15 |
now i want see how many users/persentage of users under them uses this app so that he can motivate them to use it.
As vamsi is the head i should know how many users/persentage of users under him are users in a metrix so that when i go through hierarchy there are 3 people reporting to vamsi and i should know how many users/persentage of users under them uses the app.