Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filtering by text within text column

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...
Filter
Text
  • Anonymous's avatar
    Anonymous
    3 years ago

    Finally, only this formula worked:

    FilterMeasure = CONVERT (CONTAINSSTRING( 'Table' [purpose], "FM"), INTEGER)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Finally, only this formula worked:

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