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 fellow BI users,
I have this question: I have used the path function to get the ID's for employees and their managers across levels - the data source only shows each employee and their direct manager. Now I get all levels:
Path = PATH('Dim Medewerker'[res_id],'Dim Medewerker'[repto_id])
Then I established the 8 levels necessary within our organization by adding custom columns:
Solved! Go to Solution.
I fixed it using the following;
Ok, what I came up with is this:
I fixed it using the following;
Hi @Guido_Beulen ,
Please check if these are helpful.
Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)
Or provide some sample files for testing that do not contain sensitive data? This would be very helpful, thanks in advance!
How to provide sample data in the Power BI Forum
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Cheers for the reply Gao! I need to do some more reading on ISINSCOPE, because I do feel it is a useful function but in my example it tried several things with it but could not get it to work in the way I was looking for.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |