How to use enumerate data based on a roll up to structure in a different table?

[oscargushiken]

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, @v-rongtiep-msft, @lbendlin, @amitchandak

[lbendlin]

Familiarize yourself with the PATH functions in DAX and learn about ragged hierarchies.