Multiple parents hierarchy issue

Question

Hi,I would like to compute the total cost of each product (A, B...) which are made up of subproducts. Subproducts used in other products are listed in the column "Key". The column "Cost" represent the cost of the prodcut without subproducts.As an exemple, Product F is made up of F and H (looking at the letters in column "Key" ).So its total cost is 12 (F cost)+2 (H cost)=14.Is there anyone knowing how to answer this question in DAX ?Thanks&nbsp;&nbsp;&nbsp;

lbendlin · Answer

Would you mind walking us through the logic for product A ?

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Pleases refer to the following links.
Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI&nbsp;
Bill of Materials (BOM) solution in Excel and PowerBI&nbsp;
Parent-Child Hierarchies with multiple parents in Power BI with Power Query&nbsp;
&nbsp;
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.
&nbsp;
Best Regards
Community Support Team _ Polly
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Multiple parents hierarchy issue

2 Replies