Refresh values based on visiual selection

[AlaIssa]

Dear all,

I would appreciate your help / insight on the below

I have one table conains two targets as below 

example:

column1 target1 column2 target2

X              90%         Y       100%
A              99%         B        95%
I have two matrix visiual 

Matrix1: contains data of column1 & target1

Matrix 2: contains data of column2 & target2

so if I click or filter matrix1 visiual, value X

I need that matrix2 set the target as of X (90%) for rows / values of Y and B

instead of Y = 100% should be 90%
instead of B = 95% should be 90%

thanks in advance for any insight  

[Daniel29195]

you can try creating this measure : 

Target 2 - measure = 

switch( 

true(),

isfiltered(column1) ,  max ( target1) ,

max ( target2)

)

let me know if it works for you , 

[AlaIssa]

Thank you so much it works perfectly 

so when I click first visual I get in the second one what was the selected tarrget,

what if I want to add other is filtered in same measure

so when I click second visual I get the selected target in visual 1

[Daniel29195 · Accepted solution]

i understand that you also want , you want also the same effect on visual 1 if you filter from visual2  . 

if that so, you can create a measure : 

Target 1 - measure = 

switch( 

true(),

isfiltered(column2) ,  max ( target2) ,

max ( target1)

)

[AlaIssa]

Thanks a lot

can I use same measure to define both filters ?