Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Single search filter for multiple columns

Hi,

I would like to add a search filter where my search criteria could be from any of the columns. 

Let's say I have a table with 4 columns - Name, Contact Number, Address and Occupation. I want a single search filter where I can enter either Name or Contact Number or Address or Occupation and the results would display information from all the columns related to that entry.

 

I have added 'Text Filter' add on which makes it easy to search but I need to add four different filters now.

Please help!

 

Need Help
Tutorial Requests

1 Reply

  • MauriceMecowe's avatar
    MauriceMecowe
    Resolver II
    7 years ago

    AnonymousYou will have to write 2 measures in order for this to work. First measure to select the result from the second meaure. Second measure is an IF statement with for times an OR clause, to refer to the correct columns 

     

    Measure = FIRSTNONBLANK('Table[Column],1)
    ColumnFilter = (IF(ISERROR(SEARCH[Measure], FIRSTNONBLANK(Table[Column],1))) = FALSE ||