bvanscoy678
08-17-2014, 05:47 AM
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
=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