Parent child hierarchy count children

[vamsikrishna140]

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

[lbendlin]

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

[vamsikrishna140]

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.