Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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)
)
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 ,
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
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)
)
Thanks a lot
can I use same measure to define both filters ?
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |