PATH() Multiple Value error

Quinn_Punisher8 — Thu, 02 Nov 2023 07:13:30 GMT

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 ?

Re: PATH() Multiple Value error

adamtsummers — Thu, 02 Nov 2023 11:28:51 GMT

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

Re: PATH() Multiple Value error

Quinn_Punisher8 — Fri, 03 Nov 2023 05:46:39 GMT

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

topic Re: PATH() Multiple Value error in DAX Commands and Tips

PATH() Multiple Value error

Re: PATH() Multiple Value error

Re: PATH() Multiple Value error