Page 1 of 1

Total Volume of Product That Contain X Material

Posted: Thu Sep 26, 2019 4:41 pm
by 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

Re: Total Volume of Product That Contain X Material

Posted: Fri Nov 01, 2019 5:26 pm
by MattAllington
I don’t really understand the question, but you may find this article useful. https://exceleratorbi.com.au/many-many- ... explained/