I've discovered that if I groupe by only the necessary columns it filters correctly. I little bit weird. I was hoping to upload the file directly, but cannot do that. I'll put it in Google Drive and share it.

Introduction If you’ve found yourself here, you’ve probably been asked to create a reproducible example, or reprex, in response to a question you asked on the RStudio Community Site. This post provides a cursory overview of both creating a reprex as...

Right now the is an issue with the version of reprex that is in CRAN so you should download it directly from github.

Until CRAN catches up with the latest version install reprex with

devtools::install_github("tidyverse/reprex")

We ask for a reprex because that is the quickest and easiest way for us to help you. Almost everyone here is answering questions in their spare time and anything you can do to reduce the time it takes to answer your question is appreciated.