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