Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I currently have a column of data that shows actual lead time for each order. If actual lead time is less than or equal to requested lead time, then OTIF condition is met. I want to plot a graph of the % of orders that meet OTIF against the requested lead time (range of 0-120 days). Basically, I need a measure or something to run in a loop to plot the graph. So, if requested lead time is 1, then calculate the % of orders that meet OTIF, and plot the data point. If requested lead time is 2, then calculate the % of orders that meet OTIF and plot the data point, and so on. Is there a code or something that can do this?
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Sales Order | Actual Lead time (days) | If lead time requested=70 days |
10622661 | 40 | OTIF |
10622669 | 52 | OTIF |
10622722 | 56 | OTIF |
10622725 | 48 | OTIF |
10622730 | 61 | OTIF |
10622733 | 27 | OTIF |
10622751 | 75 | MISS |
10622753 | 68 | OTIF |
10622762 | 62 | OTIF |
10622762 | 62 | OTIF |
10622900 | 76 | MISS |
10622903 | 82 | MISS |
10622905 | 94 | MISS |
10622912 | 104 | MISS |
10622916 | 139 | MISS |
10622918 | 107 | MISS |
10622921 | 131 | MISS |
10624717 | 44 | OTIF |
10624911 | 61 | OTIF |
10626347 | 87 | MISS |
10626350 | 102 | MISS |
10626350 | 102 | MISS |
10626794 | 135 | MISS |
% of orders with OTIF (for requested lead time of 70 days) = 11/23*100= 47%
So basically for each lead time requested (range of 0-140 days), calculate the % of orders with OTIF. Then plot the y value (% of orders with OTIF) against the x value (lead time requested).
Hi @Anonymous
Not quite understand what you're looking for, what's your expected results? and how's the calculate logic?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |