Total Volume of Product That Contain X Material

Anything related to PowerPivot and DAX Formuale
Posts: 20
Joined: Wed Oct 17, 2018 5:23 am

Total Volume of Product That Contain X Material

Postby Jonny1010101010 » Thu Sep 26, 2019 4:41 pm

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

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 0 guests