COUNT(Distinct paEmKey) AS EmployeesCountI also need another count, but that would be based on a condition of another field.
CASE Balance <> 0.00 THEN COUNT(Distinct paEmKey) ELSE 0 END AS EmployeesCountWithBalancesI thought perhaps a subquery, but maybe there is a better way?