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 th...
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.

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