Filter table by column based on values from another's table column

[em6jq65]

Hello guys! 

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!

[v-yuta-msft]

Hi em6jq65,

Could you share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao