Forum Discussion

pete1234's avatar
pete1234
Frequent Visitor
1 year ago
Solved

Slow Response Measure

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.

 
General Comment
Need Help
Tutorial Requests
  • moncx's avatar
    moncx
    1 year ago

    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.

3 Replies

  • moncx's avatar
    moncx
    Resolver II
    1 year ago

    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.

  • Darui6's avatar
    Darui6
    Frequent Visitor
    1 year ago

    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])