Forum Discussion
POWER BI [Calculation % on time performance] Metrics
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 -1...
Dinesh_Suranga
Continued Contributor
Continued ContributorCh3ris ,
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.
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)