Filtering by text within text column

[Anonymous]

Hello amazing community!

Does anyone know if it is possible to create a mesure which will filter the column 'purpose' and return only those rows which contain exact wording, for example, 'design' as on the below screenshot?

Many thanks for any formula suggestions!

Anna

[Anonymous · Accepted solution]

Finally, only this formula worked:

FilterMeasure = CONVERT (CONTAINSSTRING( 'Table' [purpose], "FM"), INTEGER)

[tamerj1]

Hi @Anonymous 

is it only one key word or you have list of key words placed in a separate table?

If so then you can place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter.

FilterMeasure =
COUNTROWS (
    FILTER (
        CROSSJOIN ( VALUES ( 'Table'[Purpose] ), VALUES ( List[KeyWord] ) ),
        CONTAINSSTRING ( 'Table'[Purpose], List[KeyWord] )
    )
)