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 added conditional col, still it showing same data and count.

GMI =

COUNTAX(PTS,PTS[Short Description] IN {"GMI","IBM"})

My Data - 

 





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

3 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super 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"))