Results 1 to 4 of 4

Thread: Using MINX for Fire Department Response Times

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Using MINX for Fire Department Response Times

    I"m using the below formula to find the fastest response times to a fire alarm.



    The apparatus table contains each units response and it has a relationship to the incident table that has just one incidentkey per call.

    I tried the logic of counting the rows of the incident table where the response time was <320, but it returns the same number in the pivot all the way down.

    =CALCULATE(COUNTROWS(FILTER(incident,[CalculateRound Min Response Time]<320)),

    I'm a bit lost and would appreciate any ideas or help.

    Thanks, Brent
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts