Forum Discussion

Manasi25's avatar
Manasi25
Icon for Helper II rankHelper 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.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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"))