Here is my case:
I have a table with all shipments for a month ([EAN], [Amount], [Price], etc), so the column values are NOT distinct (unique).
So I have a measure that calculates the SUM of ALL shipments for the month.
But from now I also have a table with target values for every EAN I sell ([EAN], [Total Target For The Month]). The problem is that I dont have a target for every EAN I sell. So I want to see the sales of only those products, that have a target in a table. How can I do it?
Here is my dataset relationships:
Thanks in advance!