Calculating Active Agents Per Day

[Tucker1991]

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

[v-huizhn-msft]

Hi @Tucker1991,

Please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @Tucker1991,

Please use the COUNTA function which support text, dates, and logical values an so on. 

Best Regards,
Angelia

[Phil_Seamark]

Hi @Tucker1991

Any chance you can post some sample data, including expected output based on the sample data?