Forum Discussion

AutismRunner296's avatar
AutismRunner296
Frequent Visitor
2 years ago
Solved

How to filter across multiple columns with the same content

Couldn't find anything by searching, so trying my luck here.   I have a spreadsheet (from JIRA) that contains 3 columns called Label, Label1, and Label2.  They can all contain exactly the same entr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, 

    Thanks for the solution Idrissshatila  provided and i want to offer some more information for user to refer to.

    hello AutismRunner296 , you can refer to the follwing sample.

    Sample data 

    Slicer table

    Then create a measure

    Measure = COUNTROWS(FILTER(Slicer,CONTAINSSTRING(MAX('Table'[Value]),[Type])))

    Put the measure to the visual filter.

     

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

AutismRunner296's avatar
AutismRunner296
Frequent Visitor
2 years ago

How would I then filter on the merged columns, for example I could have:

 

Apple, Orange, Banana

Banana, Apple, Kiwi

 

If I wanted to filter on Banana how would I go about it

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, 

Thanks for the solution Idrissshatila  provided and i want to offer some more information for user to refer to.

hello AutismRunner296 , you can refer to the follwing sample.

Sample data 

Slicer table

Then create a measure

Measure = COUNTROWS(FILTER(Slicer,CONTAINSSTRING(MAX('Table'[Value]),[Type])))

Put the measure to the visual filter.

 

Output

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.