Calculating Active Agents Per Day

Hi,

Basically I want to calculate calculate when an Agent is active and then use that to calculate how many agents are active per day and how many days an agent is active.

I've been attempting to do this with a nested if function below as a calculated column. For some reason though it only calculated the greater than "value". I even switched the greater and less than symbols and it still only calculated the greater than "value"

Active Agents2 = IF((SUM('Agent Data Freshdesk - New'[Tickets resolved]) + SUM('Agent Data Amazon - New'[Contacts handled]))<9,"Active",IF(SUM('Agent Data Freshdesk - New'[Tickets resolved]) + SUM('Agent Data Amazon - New'[Contacts handled])>10,"Inactive"))

Now when a make a measure using this function everything works great, the only issue is I don't know how to summarize the data in a measure as the display type is text.

I'm still learning PowerBI.

Jalal