topic Re: How to show data containing Path associated with Sliced Item in DAX Commands and Tips

How to show data containing Path associated with Sliced Item

MattyKretz1594 — Wed, 18 Sep 2024 10:39:55 GMT

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

Re: How to show data containing Path associated with Sliced Item

lbendlin — Wed, 18 Sep 2024 17:59:07 GMT

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-with-power-query/

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-Forum/ba-p/963216

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/1447523

Re: How to show data containing Path associated with Sliced Item

Anonymous — Thu, 19 Sep 2024 05:31:19 GMT

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.