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....
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] ) ) 
)
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] ) ) 
)