How to show data containing Path associated with Sliced Item

[MattyKretz1594]

Hi All,

I would very much appreciate your help on an issue I am having. I have a table that contains the following data seen below:

The current data is filtered for a specific part and it's hierarchy, to make visualising the request easier. I have created a table visual containing "ItemID" and have a slicer to filter for specific ItemIDs. I would like to write a DAX formula that acts as a filter for the table visual, where if a user selects a specific ItemID it will show that Item and all child parts below that. I have written the following formula but it doesn't seem to work:

The logic is essentially to find the ChildId associated with the Selected ItemId, find the HierarchyPath for that ChildId and then return any parts that start with that HierarchyPath.

Your help would be much appreciated and I am happy to clarify anything that is not understood.

Thanks,

Matthew

[Anonymous]

Hi, @MattyKretz1594 

Can you give an example of what you would expect as a result of the data?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You don't seem to be using any of the PATH functions.

Of note:  https://www.thebiccountant.com/2019/10/03/parent-child-hierarchies-with-multiple-parents-in-power-bi...

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...