Forum Discussion
Filter Table visual based on strings
Hi WilliamAzevedo ,
If your search criteria is constant, you may try the following DAX measure. Anything that is not blank matches any of the text string. Just change the text strings accordingly. Also attached is a sample pbix for your reference.
Filter = VAR CriteriaTable = DATATABLE ( "Criteria", STRING, { { "poca" }, { "santana" }, { "com risco" } } ) RETURN COUNTROWS ( FILTER ( CriteriaTable, SEARCH ( [Criteria], SELECTEDVALUE ( Data[Column2] ), 1, 0 ) ) )
Hi WilliamAzevedo ,
If your search criteria is constant, you may try the following DAX measure. Anything that is not blank matches any of the text string. Just change the text strings accordingly. Also attached is a sample pbix for your reference.
Filter =
VAR CriteriaTable =
DATATABLE ( "Criteria", STRING, { { "poca" }, { "santana" }, { "com risco" } } )
RETURN
COUNTROWS (
FILTER (
CriteriaTable,
SEARCH ( [Criteria], SELECTEDVALUE ( Data[Column2] ), 1, 0 )
)
)
Hi! I tried that and the visual gave me no result. There's how I did it:
Did I do anything wrong? Did I miss anything?
Ok, I saw it: I forgot to put the columns in the visual 🤣.
Thank you very much, that's what I needed!
You can the measure to the visual filter tile and filter it from there so it doesn't show in your table . [Measure] is not empty/blank
Done and it worked! Thank you again!
