Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

Parent 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 2
lbendlin
Super User
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-...
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

indexreportingName
1vamsi 
2srikantvamsi
3maheshvamsi
4mithunvamsi
5srijitsrikant
6shankarsrikant
7patakmahesh
8srikumarmahesh
9prernamithun
10nagarajamithun
11abhishekmithun
12sahibiprerna
13atulabhishek
14maneshsrikumar
15mayurpatak

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors