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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
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