Many to many measure that summarize by product without date

[Zaoka]

Not sure how to call this,

Basically I have 3 tables: import, sales, and product details . I need to create measure that show sales by product in import table, so when I filter import date i see total sales by product and imports only for filtered date.

I tried with basic SUM, but I only get Total Total sales in every row, not by product.


excel example

Import.Sales.xlsx

Shared with Dropbox

www.dropbox.com