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!!

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

Manasi25 

i think the parameter after  FILTER should be a table.

maybe try to change FILTER('PTS [Short Description]'  to FILTER(PTS

    • shafiz_p's avatar
      shafiz_p
      Super User
      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!!