Total Volume of Product That Contain X Material

Anything related to PowerPivot and DAX Formuale
Jonny1010101010
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

MattAllington
Posts: 1067
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Total Volume of Product That Contain X Material

Postby MattAllington » Fri Nov 01, 2019 5:26 pm

I don’t really understand the question, but you may find this article useful. https://exceleratorbi.com.au/many-many- ... explained/
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest