Nope that's still a limitation and a tricky one to solve, and I agree it's really really annoying. I added support for filtered aggregates[1] in this release,

Nope that's still a limitation and a tricky one to solve, and I agree it's really really annoying. I added support for filtered aggregates[1] in this release, if you're annotating multiple counts this might be useful for you. 1. https://docs.djangoproject.com/en/2.0/ref/models/conditional-expressions/#conditional-aggregation https://docs.djangoproject.com/en/2.0/ref/models/conditional...