Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I need to find out the number of direct reportees & all reportees (both direct & indirect meaning reportees of reportee) if a person is filtered or selcted
ID | Name | Manager ID | Manager Name |
730810 | Ravi | ||
752875 | Tancu | 730810 | Ravi |
738072 | Krishna | 730810 | Ravi |
730287 | Schmidt | 730810 | Ravi |
755268 | Daskalaki | 730810 | Ravi |
751643 | Ugochukwu Okechukwu | 730810 | Ravi |
751772 | Skjønning Andersen | 730810 | Ravi |
755737 | Pertho | 730810 | Ravi |
731083 | Nielsen | 730810 | Ravi |
731208 | Selvaraj | 730810 | Ravi |
755650 | Kumar | 738072 | Krishna |
754081 | Babuji | 738072 | Krishna |
739592 | Rajesh | 738072 | Krishna |
738880 | Arun | 738072 | Krishna |
753018 | Varun | 738072 | Krishna |
739093 | Jagadesh | 738072 | Krishna |
738738 | AG Umapathy | 738880 | Arun |
738948 | Kalyanaraman | 738880 | Arun |
739148 | Kumar | 738880 | Arun |
755307 | SOUNDARARAJ | 738880 | Arun |
Above is my dataset
Now if I filter manager Ravi, I should get the count of Direct Reportees as 9 and total reportees as 19 separate cards & also I need the list of direct reportees names to be shown in a table and list of all reportees in another table
Similarly if I select Krishna, I should get the count of Direct Reportees as 6 and total reportees as 10 in separate cards & also I need the list of direct reportees names to be shown in a table and list of all reportees in another table
Based on filter the results shall apply. Also let me know if I can have another hierarchy table from the dataset
Can you please help me to get this result, if possible please attach the pbix file with the sample dataset
Regards
Mahes
Solved! Go to Solution.
@AlexisOlson Im nt too good in Power BI.
Could you please send me the developed pbix. It will be really helpful on my current role.
If not please explain on "a parameter table of all reportees to use as a slicer, and use PATHCONTAINS to check which paths include the slicer selected reportee"
Regards
Mahes r
I linked to it.
Hint: The various PATH functions will likely be useful here. You'll probably want to set up calculated column Path = PATH ( [ID], [Manager ID] ), a parameter table of all reportees to use as a slicer, and use PATHCONTAINS to check which paths include the slicer selected reportee.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |