Many to many relationship in tables issue

[Alexander32]

Hello,


I need to link 2 tables(Sales and ingridients in cards) to each other with many to many relationships.
Basicly, i want to see sales information on sandwitches and amounts of ingridients used to make those sold sandwiches.
It is very hard to explain without showing in the attachment, so i've uploaded a file to rapidshare. here is the link: http://rapidshare.com/files/3387237...g tables with many to many relationships.xlsx


In the attached file i've tried to do so, also created 2 bridge tables, but i cant achive required result. I've read that it can be done by using dax function related, but i cant figure out how.


The data tables are located in list "data", the required result is located in list "sales+ingridients in cards".


Thank you very much for your help.

Sincerely yours,
Alexander.

 

[Alexander32]

Anybody? :/ Please...

 

[Laurent C]

You have tables for Ingredients and Sandwiches, and tables for Sales and Receipes. If you want to propagate any filter that applies to Receipes, you can use

[Your Measure] :=
CALCULATE ( YourExpression
, 'Receipes'
)