Using Path DAX for Hierarchy

[DCS2011]

I have multiple columns, but one is NAME w/ orgs names, and the other PARENT with parent of the NAME. The values with no parent are blank.

Using:

Entity Path = PATH('DW Orgs'[Name],'DW Orgs'[Parent])

Getting Error:

The value '' in 'DW Orgs'[Parent] must also exist in 'DW Orgs'[Name]. Please add the missing data and try again.

But I checked but all parents are listed in the name colume, except for the Null Values. How do I fix this error?

Thank you.

[Anonymous]

Hi @DCS2011 ,

I think your table may look like as below.

I can reproduce the same issue on myside.

There are two requirements to PATH:

• You must have all parents defined as children
• You can't have more than one parent for each child

So make sure your table look contains the parent in children column. 

Best Regards,

Rico Zhou

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

[DCS2011 · Accepted solution]

The issue was the blank parent were not null values. Once I replaced them it work.