Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Check if anything from a list appears in a text string

Hi all,   I've been working with a measure which checks if a selection in a filter appears in another table and filters accordingly. It looks like this:   VizData_Matched = VAR searchvalue=SEARCH...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this calculated column formula

     

    =FIRSTNONBLANK(FILTER(VALUES(MatchList[Campaign Filter]),SEARCH(MatchList[Campaign Filter],VizData[Message],1,0)),1)

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this calculated column formula

 

=FIRSTNONBLANK(FILTER(VALUES(MatchList[Campaign Filter]),SEARCH(MatchList[Campaign Filter],VizData[Message],1,0)),1)

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Ashish_Mathur - that's working perfectly. Thanks to v-piga-msft for your assistance too!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      You are welcome.