Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a dataset like below where I have ManagerHeirarchy of an employee representing his line-reporting:
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.
Solved! Go to Solution.
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/
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/
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |