Slow Response Measure

[pete1234]

Hello,

I have a slow response measure for a ticketing system, which reads,

Slow Response Count = CALCULATE([Ticket Count],'Support Tickets'[Slow Response Flag]=1)

This counts all tickets that have a slow response flag in their column. A ticket will have a slow response flag if they take longer than 3 days to respond to.

Slow Response Flag = if('Support Tickets'[Response time]>=3,1,0)

This is then entered into a bar chart that has a KPI indicator next to it, comparing the current month to the previous month. 

Given September is not over, there are no tickets with a slow response flag, as shown in the bar chart. However, how can I make the KPI indicator say "0" - as the sum of slow response flags = 0.

Thanks.

[Darui6]

Hi,

I'm not a 100% sure how your TicketCount Measure is defined, but I think the following formula should show you a 0 instead of nothing:

Slow Response Count formatted = IF(ISBLANK([Slow Response Count]), 0, [Slow Response Count])

[moncx · Accepted solution]

Hey,

try to modify your measure to something like this:

Slow Response Count =
if(
CALCULATE([Ticket Count],'Support Tickets'[Slow Response Flag]=1)=BLANK(),
0,
CALCULATE([Ticket Count],'Support Tickets'[Slow Response Flag]=1)
)

if the value is blank (meaning there are no slow responses) then it returns 0, otherwise it returns the number of slow respones.

Hope it helps!

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[pete1234]

That worked, thank you!!!