Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I am attempting to enumerate a list of all the Employee_IDs that exist in an Organizational hierarchy, and not getting very far.
Meaning that if I were to select a particular Org_Unit_Mgr in my slicer, that I might be able to see all the employees that are under that Org_Unit_Mgr by tracking the relationship of how the Organizational units roll up to each other.
EMPL_ORG_HISTORY | ||||
Employee_ID | Employee_NM | Org_Unit_Code | Start_Date | End_Date |
00000001 | John Doe | 1230 | 1/1/2022 | 12/31/2023 |
00000002 | Jennifer Mary | 2340 | 1/1/2022 | 12/31/2023 |
00000003 | Matthew John | 3450 | 1/1/2022 | 12/31/2023 |
00000004 | David Michael | 2342 | 1/1/2022 | 12/31/2023 |
00000005 | Richard Joseph | 2344 | 1/1/2022 | 12/31/2023 |
00000006 | Christopher Robin | 3452 | 1/1/2022 | 12/31/2023 |
00000007 | Donald Duck | 3456 | 1/1/2022 | 12/31/2023 |
00000008 | Charles Martel | 3453 | 1/1/2022 | 12/31/2023 |
00000009 | William Wallace | 3454 | 1/1/2022 | 12/31/2023 |
00000010 | Forest Gump | 2342 | 1/1/2022 | 12/31/2023 |
00000011 | Dan Taylor | 2344 | 1/1/2022 | 12/31/2023 |
00000012 | Winnie Poo | 3452 | 1/1/2022 | 12/31/2023 |
00000013 | Mickey Mouse | 3456 | 1/1/2022 | 12/31/2023 |
00000014 | Clark Kenneth | 3453 | 1/1/2022 | 12/31/2023 |
00000015 | Bruce Wayne | 3454 | 1/1/2022 | 12/31/2023 |
00000016 | Tim Drake | 3454 | 1/1/2022 | 12/31/2023 |
ORG_HIST_EXPLODE | ||
Org_Unit_Roll_To | Org_Unit_Code | Org_Unit_Explode |
null | 1230 | 2340 |
null | 1230 | 3450 |
1230 | 2340 | 2342 |
1230 | 2340 | 2344 |
2340 | 2342 | 2342 |
2340 | 2344 | 2344 |
3450 | 3452 | 3453 |
3450 | 3452 | 3454 |
3450 | 3456 | 3456 |
3452 | 3453 | 3453 |
3452 | 3454 | 3454 |
So that if in my slicer I were to select Christopher Robbin as my Org_Unit_Mgr, then I would see a table visual listing out not just Winnie Poo, but also include Charles Martel, Clark Kenneth, William Wallace, Bruce Wayne, and Tim Drake.
In short what is a good way to enumerate/display employee data based on a roll up to structure in a different table?
@Ashish_Mathur, @Anonymous, @lbendlin, @amitchandak
Familiarize yourself with the PATH functions in DAX and learn about ragged hierarchies.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |