Forum Discussion

Manasi25's avatar
Manasi25
Helper II
2 years ago
Solved

Filter column by specific words

Hello Team I have Col named "Short Description" from where i want to create new col by filtering with specific words from short description. I used below dax for it, but unable to count, also i...
General Comment
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Manasi25 

    pls try if this is what you want

    Measure = CALCULATE(count('Table'[short description]),CONTAINSSTRING('Table'[short description],"GMI")||CONTAINSSTRING('Table'[short description],"IBM"))
  • Manasi25's avatar
    Manasi25
    2 years ago

    Thank you for help ! It worked.

Manasi25's avatar
Manasi25
Helper II
2 years ago

Thank you for help ! It worked.

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

you are welcome