from django.db.models import Count Members.objects.values('designation').annotate(dcount=Count('designation'))