Forum Discussion
Solved
Using Path DAX for Hierarchy
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'[Pa...
The issue was the blank parent were not null values. Once I replaced them it work.
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.
The issue was the blank parent were not null values. Once I replaced them it work.