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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Saniat
Helper V
Helper V

Employee Manager Hierarchy

Hi,

I have a dataset like below where I have ManagerHeirarchy of an employee representing his line-reporting:

Saniat_2-1643801278864.png

 

 


I have managed a list of Managers (who appear in the column DirectManager).

I want to have this list as a Selection.

When I select a value from this Selection, I want the report to filter for his Reporting Hierarchy.

If I select 202 from the Selection, EmployeeIDs selected will be 202 (employee himself) and 101 (his reporting hierarchy).

If I select 504: 103, 202, 504 will be selected.

Can anyone please guide me to the most efficient process to achieve this.

I am happy to change the data format if required, e.g. putting the mgr hierarchy in seperate column like Mgr1, Mgr2, Mgr3.

Thanks.

1 ACCEPTED SOLUTION
sreenathv
Solution Sage
Solution Sage

The right method is to flatten the input table using PATH() and PATHITEM() kind of functions. You can refer to the following article https://www.daxpatterns.com/parent-child-hierarchies/ 

 

View solution in original post

1 REPLY 1
sreenathv
Solution Sage
Solution Sage

The right method is to flatten the input table using PATH() and PATHITEM() kind of functions. You can refer to the following article https://www.daxpatterns.com/parent-child-hierarchies/ 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.