Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
71 | |
49 |
User | Count |
---|---|
142 | |
133 | |
110 | |
68 | |
55 |