Multiple parents hierarchy issue

[Anonymous]

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

[Anonymous]

Hi @Anonymous ,

Pleases refer to the following links.

Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI 

Bill of Materials (BOM) solution in Excel and PowerBI 

Parent-Child Hierarchies with multiple parents in Power BI with Power Query 

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

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