Forum Discussion

rqh's avatar
rqh
Frequent Visitor
2 years ago
Solved

On-Time Delivery Measure on Report

Hi everyone!

 

I'm looking to display on-time deliveries on the shipping segment on my report/dashboard.
I already created a calculated column to determine which line is either "on time" or "late."

All I need now is a measure that displays the amount of on time deliveries as a percentage. This is to compare delivery consistencies between several shipping companies. For example, Company ABC delivered 90% on time, and Company XYZ delivered 82% on time.

Please help me with creating a measure for this. If you think I approached this problem wrong from the start (my calculated column), feel free to enlightment me as well!

Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    2 years ago

    rqh there are many ways to solve this, here is a measure you can calculate on time %

     

    Count = COUNTROWS ( YourTable )

OnTime % = 
DIVIDE ( 
    CALCULATE ( [Count], 'YourTable '[OnTimeLateColumn] = "OnTime" ),  
    CALCULATE ( [Count], ALLSELECTED ( 'YourTable '[OnTimeLateColumn] ) ) 
)

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    rqh there are many ways to solve this, here is a measure you can calculate on time %

     

    Count = COUNTROWS ( YourTable )

OnTime % = 
DIVIDE ( 
    CALCULATE ( [Count], 'YourTable '[OnTimeLateColumn] = "OnTime" ),  
    CALCULATE ( [Count], ALLSELECTED ( 'YourTable '[OnTimeLateColumn] ) ) 
)