Percent Complete on Time

This is the formula used to calculate Percent Complete on Time for '311 TPW CSRs' dataflow in Power BI

Percent Complete on Time = 
VAR onTimeCSRs = SUM('311 TPW CSRs'[Closed on Time])
VAR totalCSRs = onTimeCSRs + SUM('311 TPW CSRs'[Closed Late])
RETURN
DIVIDE(onTimeCSRs,totalCSRs)

Last updated