Hey @GJ217 ,
First of all, I recommend that you create your Status column on Power Query (you can use the Conditional Column).
After that, the mesaure to count the values of the Inactive can be like:
count_inactives = CALCULATE(COUNTROWS(Manager),FILTER(Manager, Manager[Status] = "Inactive"))
*** manager is my table name
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.