Create a Hierarchy from elements on the same columns

[ale-hd]

Hi All, hope all the best for you all.

I could share the .pbix file for this case but I don't know how! I will do it with please if anybody explains me how. Looking at it would probably more effective than my description.

Anyway simple starting point: 2 tables, 1st is Sales, 2nd is Channels (where the sales are from).

Looking at the matrix at the bottom below, you will see the Channels as columns headers, but this result is wrong.

The problem is in the "Channels" table:

channels are all in the same columb but actualli they are from different levels: i.e. level 1 is Web, sublevels are "Direct", "Campaign" and each of this sublevel can have as many subsequent sublevels as you like.

The problem is that the software generates all the leveles in the same table. As you can see in the image they are all listed together with the field "Level" that indicates the level.

In this specific case the operators created up to the 3 level, but the number of level can change depending on the single client. 

The question is: How can I create a Hierarchy on the Channels? 

Thank  you very much!

[v-kelly-msft]

Hi  @ale-hd ,

Would you pls provide some sample data for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[ale-hd]

Hello Kelly, I have a pbix file created as example to share it, but I do not know how to do it...

Thank you.

[lbendlin · Accepted solution]

@ale-hd Have you tried creating a PATH column from your Channels table columns?

[ale-hd]

Thank you @lbendlin thanks to your suggestion I have found this article which describes and solves my exact case! 

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

Thanks to @v-kelly-msft for having proposed to investigate further into my question.

Alessandro.