PATH() Multiple Value error

[Quinn_Punisher8]

I want to create a child-parent hierachy in Powerbi for below data where I have duplicate value in name column which have different Parents. Using PATH() and its giving error -

In such cases, how to create a Parent-Child Hierachy ?

[Quinn_Punisher8]

Thanks @adamtsummers ,  So is there any alternative soultion rather than using PATH() for achieving child-parent hierachy approach for above scenario?

[adamtsummers]

Hi there,

Its not possible to have a node with two different parents and use PATH -- its designed for a strict parent/child relationship which looks like a tree, eg:

By looking at the data that you have in your table, it looks like you have two different areas called MSS001, that are based in different countries (US and India). To be able to use path, your items need a unique name.

Have a look here: PATH function (DAX) - DAX | Microsoft Learn

You'll see the following:

• If ID_columnName has duplicates and parent_columnName is the same for those duplicates then PATH() returns the common parent_columnName value; however, if parent_columnName value is different for those duplicates then PATH() returns an error. In other words, if you have two listings for the same employee ID and they have the same manager ID, the PATH function returns the ID for that manager. However, if there are two identical employee IDs that have different manager IDs, the PATH function returns an error.

Hope this helps!

Adam