Need help - how to calculate the sum of quantity of subcomponents having the final products quantity

[Jarek1]

Hello everybody,

I struggle with this kind of challange

there is a list of unique final products.

there are also subcomponets.

there is a relationship between final product and subcomponets.

but I would like to have the sum of each subcomponents basing only on Final Products quantities.

I am struggling with a proper measure or I have the relationship wrong. I don't know.

 

final product quantity

[v-jiascu-msft]

Hi @Jarek1,

Can you share the pbix file please?

Best Regards,

Dale

[Jarek1]

Hello @v-jiascu-msft

thank you for your help.

below please find the pbix file.

file

Dear @Greg_Deckler

thank you for further information on how to procceed with posting notes.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490