Remove blanks from hierarchy with different length of branches

[Anonymous]

Hey all,

I have a problem removing the empty blanks in my hierachy.

My table looks like this:

After some Power Query and Dax functions I managed to create the hierachy:

Now I wanted to create a matrix that shows the ID and the name that belongs to it, however, the matrix has a lot of empty blanks and duplicates:

I already tried

https://www.daxpatterns.com/parent-child-hierarchies/#:~:text=To%20obtain%20a%20browsable%20hierarch...

but this does not work for me since my ID is not an Integer.

Furthermore, I cannot use the filter function and just remove the blanks since my hierachy has branches with diffrent lengths and if I would remove the blanks on Level 4, for instance, it kills all branches that do not have a Level 4.

I hope someone can help me with this problem since I do not know what to do anymore😅

Best Regards 

Philipp

[harshnathani]

Hi @Anonymous ,

Please watch this video by @ruthpozuelo 

https://www.youtube.com/watch?v=MK1jwHz8hoc

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)