Hi,
Initially I posted this on the Power Query section, because the model had circular dependencies, but I’ve managed to take those out for the time being, so I can revert to (possibly) a dax solution, although I’m still happy with a Power Query solution if needed.
I’m looking for a solution to filter a complete hierarchy. The easiest way is to have a column/which for each item in the hierarchy, concatenates all the members of the current hierarchy. To do so, I would need to do the opposite of a path function & merge the normal path with the inversed path which should give the full cluster. That doesn’t seem possible so … (I think)/
For now, a dirty workaround is using PATH to get the full hierarchy. Then I will use this generated path and concatenate all paths in which the current record resides. You have a lot of duplicate values, but that’s not an issue in terms of being able to filter the hierarchy as I use “contains” for this as well.
Question is: how can I concatenate all paths where current value/record is contained (“Dirty” column). Preferrably the “IDEAL” solution but no idea where to start.
edna - Cluster Hierarchies.pbix (26.8 KB)
PS: the ultimate goal is that when I select “C”, I would like to see all items related to it, so something like calculate(countrows([Child],(pathcontains(selectedvalue(“c”),[Diry] or [IDEAL]) => with this I can set a filter on my visual > 1 to get all results.
