The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have a hierarchy list (table Fin Hier) with FH ID and Parent ID plus other columns and would like to provide ability for users to select a FH ID and then see all associated Parent ID(s) up the hierarchy.
I created a Keys table with FH Keys = SUMMARIZE('Fin Hier','Fin Hier'[FH ID]) and linked this to a drop down selector (FH Search). This Keys table is created because i do not want to filter on the selected value itself but the parents of the selection. Then created a measure Selected Value = SELECTEDVALUE('FH Keys'[FH ID]) as shown in card below, which all work fine.
Now I need to use the pathitem function to identify all parents Level1 = pathitem(Paths,1) and then filter FH ID to just these values (1 to 7 levels depending on selection). This is where I need the help, I can't seem to crack this nut.
@Anonymous,
You just need to build relationship on 'Fin Hier'[Parent ID] and 'FH Keys'[FH ID].
Not sure how that helps.
Below i forced the filter manually to simulate the user selecting 1000267847, but this is what i want to display dynamically.