topic Re: Filtering by text within text column in DAX Commands and Tips

Filtering by text within text column

Anonymous — Wed, 14 Jun 2023 17:01:11 GMT

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

Re: Filtering by text within text column

tamerj1 — Wed, 14 Jun 2023 17:21:43 GMT

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] ) ) )

Re: Filtering by text within text column

Anonymous — Wed, 26 Jul 2023 13:52:38 GMT

Finally, only this formula worked:

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