cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
em6jq65 Frequent Visitor
Frequent Visitor

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

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:

 

32123.png 

Thanks in advance!

1 REPLY 1
Community Support Team
Community Support Team

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

Hi em6jq65,

 

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

 

Regards,

Jimmy Tao