Forum Discussion
Call Centre Daily Occupancy
Try Like
Total = Calculate(
AvergaeX(
SUMMARIZE(
vicidial_agent_log,
vicidial_agent_log[callDate],
"_agents",
DISTINCTCOUNTNOBLANK('vicidial_agent_log'[user]),
"_dates"
DISTINCTCOUNTNOBLANK('vicidial_agent_log'[callDate]),
"_comp"
),
(divide([_agents],[_dates]*24) )*100
)
)
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
- MrPatrick6 years agoHelper I
Thanks for your reply, this doesn't work however, it presents an error "Column '_comp' added by the SUMMARIZE function must have the scalar expression specified"