Plot a graph based on if analysis

[Anonymous]

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?

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

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

[v-diye-msft]

Hi @Anonymous 

Not quite understand what you're looking for, what's your expected results? and how's the calculate logic?