Forum Discussion
Slow Response Measure
- 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.
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.
- pete12341 year agoFrequent Visitor
That worked, thank you!!!