Forum Discussion
Microsoft EmployeeParent child hierarchy count children
Hi - i am having two tables one table contains users of perticular app with their user id. another table contains regional head,regional head_id, PM's under him and their id's, like that till the last level. how should i map them so that i will get the count level wise on how much persentage of employees under them are users of app or not
2 Replies
- lbendlin
Super User
Please 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
vamsikrishna140Hi- 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.
