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
Total Volume of Product That Contain X Material
-
- Posts: 20
- Joined: Wed Oct 17, 2018 5:23 am
-
- Posts: 1067
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: Total Volume of Product That Contain X Material
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
Power BI Training
Who is online
Users browsing this forum: No registered users and 0 guests