Forum Discussion

badger123's avatar
badger123
Icon for Resolver I rankResolver I
7 years ago
Solved

Text filter help

Hi all,   I'm looking for some help with something I'm struggling with. I am using the text filter visual which uses table 2 phrase as the field. I have created a relationship between Table 1 and T...
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi badger123,

     

    Similar to rajendran's suggestion, but I would prefer to add a measure to visual level filter.

    check1 = IF(SELECTEDVALUE(Table_1[item])=SELECTEDVALUE(Table_2[phrase]),0,1)

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI badger123

 

You can create a calculated column 

same item phrase = IF('Table1'[item]='Table1'[phrase],1,0)
 
and you can apply a visual filter on this column and set the filter value to 1.
 
Thanks
Raj