Select all the value in a visual table column

[Tybaal]

Hello all, 

I have a page with two tables in my report and I would like to filter the bottom table with only the contracts that are present in the top table.

I know that I can select the contracts in the top table with CTRL+Click but I'd like it to be automatic.

Here is exactly how it works :

First, I have this visual table in my report, Value 1, Value 2 and Diff are measures :

The second visual table in my report is quite the same but with a dimension "Origin" which separate my rows :

I created a button to filter the first visual table to show only diff <> 0, which give me that :

What I'd like to have is that the bottom visual table filtered on only the contracts in the top one after filtered on diff <> 0, but I cannot apply the diff <> 0 filter because of the "Origin" dimension (the diff is  always <> 0) :

Do you have a tips to do this type of operation?

Thank you in advance.

[amitchandak]

@Tybaal , Try measure like

new  value 1 =

calculate([value1], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))

New Value 2 =

calculate([value2], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))

New diff =

calculate([Diff], filter(Table, calculate([Value1] -[value2], filter(all(Table), Table[contract] =max(Table[Contract]))) <> 0 ))