PATH is not working

[joshua1990]

Hi all!

I have a simple multi level parent child table:

Parent - child

Now I would like to get the levels for each combination by using PATH as described here:

https://www.daxpatterns.com/parent-child-hierarchies/

But I always get this error if I use PATH:

The value 'ABC' in 'Table'[Child] must also exist in 'Table'[Parent]. Please add the missing data and try again.

How can I adjust the table to get this working?

[ValtteriN · Accepted solution]

Hi,

Double check that all values in parent column (besides blanks) exist in the child column. Also check if your data types match. If they don't match this error can be encountered.


E.g. Both my columns are numbers:

Now the columns are text:

The error appears here since the blank isn't null in PQ:

When I add nul to PQ the text also works:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/