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
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-...
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
Hi- 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.