How to insert many filters in a table

[Anonymous]

Hi,

I'm trying to filter a table, as the image bellow.

I'd like to filter a column to show only the results that contain the word "Media", "Muito Alta", "Alta". However, it only allowed to I insert at maximum two words. How can I put more on it?

[Fowmy · Accepted solution]

@Anonymous 

You cannot apply more than two as you mentioned. but you can create a measure and drip in the visual filter. Follow this please:

FilterMeasure: =
COUNTROWS (
    FILTER ( table, table['Primario..'] IN { "Media", "Muito Alta", "Alta" } )
)

set it to 'Grater than 0'