Only preserve the longest & unique path in parent-child relationship

[zudar]

Hi all,

I'm a little confused by the following tutorial: Parent-child hierarchies – DAX Patterns.

The parent-child table looks like:

where:

EntityPath =
PATH ( Entity[EntityKey], Entity[ParentEntityKey] )

However, in my application of this concept.. I need to only preserve the longest unique path there is from the 'first' node.

So instead of results like (example):

1

1|1

1|9

2

2|4

2|4|8

2|4|8|9

3

3|5
3|6
3|5|8

4

I would like to see:

1|1

1|9

2|4|8|9

3|6
3|5|8

4

Is there a way to do this elegantly and directly through the PATH(...) -function?

[zudar]

Other suggestions are welcome 🙃

[amitchandak]

@zudar , there is pathlength function. with that, you can create a flag

You can use that

pathlen = pathlength([path])

new flag = if( maxx(filter(Table, [id] = earlier([ID])),[pathlen]) =[pathlen],1,0)

[zudar]

Which column(s) from the sample table would you use for [id] = earlier([ID])?