Hierarchy tree with multiple parent-child levels

[Anonymous]

Hi!

I am analyzing our stock from our finished products and all its subcomponents and the components of those subcomponents.

I have 4 tabels

Table 1

Material 

Material	Component
Product A	Component A
Product A	Component B
Product A	Component C
Product B	Component A
Product B	Component D
Product B	Component E
Product C	Component A
Product C	Component F
Product C	Component G
etc.	etc.

The second table is where the components from table 1 are split up into subcomponents

Material	Component
Component A	SubComponent A
Component A	SubComponent B
Component A	SubComponent C
Component B	SubComponent D
Component B	SubComponent A
Component B	SubComponent F
Component C	SubComponent  G
Component C	SubComponent A
Component  D	SubComponent A
etc.	SubComponent

Table 3 follows the same principle where the subcomponents are split up into its components.

I have created a table 4 with all individual materials and their stock values.

With this data id like to achieve a hierarchy tree where i can analyse the Stock of the finished product and expand to its subcomponents on multiple leves.

Hope you can help me out!

Thanks in advance!

Robee

[lbendlin]

Standard hierarchies in Power BI do not allow for scenarios where a child (subcomponent) has multiple parents (component).  You will have to implement your own tables with the verbose listing of component relationships for all products.