For me it worked when I used case when statement first, created a new column and then used that new column to filter out for the observations that I wanted to keep.