Decomposition tree question

Question

hi,&nbsp;&nbsp; I have a need to have dependencies between parent/children/grandchildren etc, I'm thinking I have to use a decomposition tree ?&nbsp;&nbsp; Data looks like:&nbsp;&nbsp; Key&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KeyDependency&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;blank&nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;You can see here parent 1 has child 3 and child 3 has child 5 and child 6 and it could go several layers deep.&nbsp;I assume a decomposition tree is the way to go ?

tutu_in_yyc · Accepted Answer

Hi&nbsp;EaglesTony&nbsp;its best to break that parent child hierarchy in your table using DAX. Then you can visualize that however you want. Have a look at these tutorials.https://www.daxpatterns.com/parent-child-hierarchies/https://learn.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax

Forum Discussion

Decomposition tree question

2 Replies

Related content

Decomposition Tree Drillthrough issue

Decomposition tree for API Hierarchy

Decomposition tree dynamic

Decomposition tree filter

Decomposition tree