Forum Discussion

Manasi25's avatar
Manasi25
Helper II
2 years ago
Solved

filter table which does not contain specific text

Hello  I need to filter my table with quick measure by DAX which does not contain specific string.  I calculated it with below formula , but it does not worked. Please help ! Kinldy respond ! ...
Tips and Tricks
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    Hi Manasi25  You need to remove closing brackets in filter function. See the red mark in the given image:

     

     

    Hope this helps!!

Thejeswar's avatar
Thejeswar
Super User
2 years ago

Hi Manasi25 ,

In the DAX that you shared, there is a bracket missing at the end. Not sure if it is something missed during copy.

COUNTROWS(FILTER('PTS [Short Description]',not(CONTAINSSTRING('PTS [Short Description]',"GMI" )) &&
not(CONTAINSSTRING('PTS [Short Description]',"PTD")) &&
not(CONTAINSSTRING('PTS [Short Description]',"UTILITIES")) &&
not(CONTAINSSTRING('PTS [Short Description]',"IBM")) &&
not(CONTAINSSTRING('PTS [Short Description]',"CV")) &&
not(CONTAINSSTRING('PTS [Short Description]',"UBIX")) &&
not(CONTAINSSTRING('PTS'[Short Description],"FCD"))
not(CONTAINSSTRING('PTS'[Description],"MSGW"))))