How to add a count column for employees aligned to a job in OTBI.

Summary:

I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job in myHR. I need this to exclude Inactive employees and also count jobs which no employees are aligned too. When I used the below measure it done the count as I wanted but also removed around 2.5k jobs from my report where previously they were showing. Is there a better way to do the case? Thank you for your help!

I've added the full XML for detail. Thank you.