Forum Discussion

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago
Solved

Exclude rows

Hi, I am trying to filter a column excluding 2 job titles, but it doesn't work.   I have tried in the Query Editor with the main filter and setting "does not contain", but doesn't work.   Any oth...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi alexcatala 

    If you start with data like this in the Query Editor

     

    Click on the filter button on the Job Title column and uncheck the jobs you want to remove and click OK

     

    Leaving you with this

     

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

alexcatala , a measure to filter these two


measure =
calculate(countrows(Table), filter(Table, not(Table[job] in {"Assitant Manager","Supervisor"})))

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
5 years ago

Hi amitchandak 

 

I am not trying to count the rows, I just want to remove these values and keep seeing the remaining as a text. Because are text values and we want to keep seeing what the main job title to be able to filter them.