POWER BI [Calculation % on time performance] Metrics

[Ch3ris]

Hi All,

Can anyone help me on how to calculate % on time percentage based on early , late , on time accuracy  on creating new measure / power query etc? Thanks 

For example  

Order No  -1234 

Accuracy - On time

Box Quantity - 1

Thanks

Chris 

[Dinesh_Suranga]

@Ch3ris 

Hi,

Could you please explain your question little bit more?

Thank you.

[Ch3ris]

Hi ,

I wish to use it to calculate sales order delivery performance whether is meet on time, late, early

For example :  Suppose to deliver to customer on 31/10/2022 , but got delivered to customer on 30/10/2022 which is early

So for me currently, i have data that is Customer Delivery Accruacy - On Time, Late , Early

Box quantity , sales order number count

but i want to calculate them in separate for those on time order %, late order % , and early order % 

Sales Order Number Customer Expectation Delivery Date Delivery Accuracy Box Quantity
1234                                    03/08/2022 00:00:00                          Early                      1 

[Dinesh_Suranga]

@Ch3ris ,

Hi,

1 Add "Delivery Accuracy" column to a table.

2 Create a mesure using following DAX formula (Change table name and column name as your data model).

% = 

// Get all Customer Delivery Accruacy

VAR TotalCount =  CALCULATE(COUNT('Table'[Delivery Accuracy]),  ALL('Table'[Delivery Accuracy]))

// Get Customer Delivery Accruacy for each type

VAR RelatedCount = CALCULATE(COUNT('Table'[Delivery Accuracy]),  'Table'[Delivery Accuracy] = SELECTEDVALUE('Table'[Delivery Accuracy]))

RETURN

Divide(RelatedCount,TotalCount)

3 Add % mesure to your table.

If you have any question regarding this solution please reply to this message.

Please acept this as solution if it helped you to solve the issue.

Thank you.

[Ch3ris]

can you help on this please, Sir 

[Ch3ris]

i tried the formula and i don't have the same , not sure why that on time , late, early category didn't come out 😞 ( My EDD accuracy table got 3 types , early, late , on time)