Forum Discussion

broeren79's avatar
broeren79
Frequent Visitor
6 years ago
Solved

on time delivery

Hi all,   Newby here, please go easy. I need to be able to visualize some performance measurements based on variables spread over 3 tables. My table structure: Table1: Incidents IncidentID ...
Need Help
  • richbenmintz's avatar
    richbenmintz
    6 years ago

    Hi broeren79 

     

    Assuming that your model looks like this 

     

    you can create a calc column to get you on time and late values

    Status = if([Duration] > RELATED(DurationNames[Target]), "Late", "On Time")

    and a measure for your % on time

    % On Time = DIVIDE(CALCULATE(COUNTROWS('Incidentdurationblocks'), filter('Incidentdurationblocks','Incidentdurationblocks'[Status] = "On Time")), COUNTROWS('Incidentdurationblocks'))

     

    I hope this helps,

     

    Richard

broeren79's avatar
broeren79
Frequent Visitor
6 years ago

thanks Greg_Deckler , i'll be sure to sure to check out the cookbook.