Filter column by specific words

[Manasi25]

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 - 

[ryan_mayu · Accepted solution]

@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 · Accepted solution]

Thank you for help ! It worked.

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

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