Forum Discussion

em6jq65's avatar
em6jq65
Frequent Visitor
7 years ago

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:

 

 

Thanks in advance!

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi em6jq65,

     

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

     

    Regards,

    Jimmy Tao