Using MINX for Fire Department Response Times

[bvanscoy678]

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

=CALCULATE(MINX(apparatus,[RoundResponse]),
FILTER(uv_901ACTION,uv_901ACTION[Top_Category]="Fire"),
                       FILTER(apparatus,[RoundResponse]>1), 
FILTER(incident,incident[priorityresponseflag]=TRUE()),
FILTER(uv_901APP_TYPE,uv_901APP_TYPE[Description]="Engine"))

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)),
Filter(uv_901ACTION,uv_901ACTION[Code_Category]="1"))

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

Thanks, Brent

[Bob Phillips]

Any chance of posting a workbook with data loaded that we can play with?

[bvanscoy678]

I tried to post a link, but I don't have enough post on the forum to allow it.
I've modified the original content to cover about 14 days. If you send me an email, I'll send you the workbook.

bvanscoy678 at gmail.com
Thanks for looking. Brent

[SamT]

C'mon guys. Keep it in the forum.