Total Volume of Product That Contain X Material

[Jonny1010101010]

Hi all,

I've been racking my brain over this one, but I'm not understanding the right way to manipulate the context - if anyone knows the simplest way?

Scenerio -

Table1 - Sales Volume by Product (fact table)
Table2 - Product Bill Of Material, kgs of each material per sales kg (fact table)
Table3 - Products list (bridge table between the above)
Measure1 - Material Quantity per Product

The measure I cant figure out:

Measure2 - the total sales kgs contain the material in the filter context - not the requirement of the material within the sales

Any ideas, thanks Jonny