cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Cumulative Count with KPI

Hi, cumulative counts are covered extensively here but I can't see an answer to my specific problem.

 

I'm trying to cumulatively count the number of calls a team of agents make in a day and benchmark them against a cumulative KPI.

 

First I summarize the the number of agents per day based on the calls table.

 

Active Agents = CALCULATE(COUNTROWS(SUMMARIZE(Calls,Calls[Date],Calls[AgentID])),FILTER(Calls,Calls[Role]="SalesAgent"))
 
Then create the cumulative KPI for the calls up to yesterday and summed over "This Week"
 
Calls KPI = CALCULATE([Active Agents]*60,ALL(Dates),Dates[This Week]="This Week",Dates[Date]<TODAY())
 
This works fine but when I do something similar for the number of calls they actually make during the week the KPI only shows me the previous day's total.
 
Outbound Calls = CALCULATE(COUNTROWS(Calls),FILTER(Calls,Calls[Type]="O"),FILTER(ALLSELECTED(Dates),Dates[Date]<TODAY()))
 
Calls summarized week.PNG

 

Calls.PNG

 You can see in the images above when I inclide a date on the trend axis for the KPI the calls KPI is cumulative however the actual count of calls made is not. Removing the date gives the true cumulative figure for calls made but removes the trend axis.

 

Can someone please help?

3 REPLIES 3
Highlighted
Solution Specialist
Solution Specialist

Re: Cumulative Count with KPI

Hi,

You have ALLSELECTED in your formula, this might be restricting your data.

Highlighted
Frequent Visitor

Re: Cumulative Count with KPI

Hi,

 

Thanks for the response. I've tried a few different filters within the CALCULATE function and nothing seems to work. I've tried ALL and also tried date < MAX(date). Can't understand why it works for the "Calls KPI" measure but not for the actual count of the calls.

 

Probably should have mentioned I'm struggling to get my head around context!

 

Cheers, 

Highlighted
Solution Specialist
Solution Specialist

Re: Cumulative Count with KPI

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors