Count of date which are from diffent days

[Fefo]

Situation:

Planned date - Date when the order was planned

Finish Date - Date when the order was completed (must be the same as planned)

Delay - When was not done as planned

In my stack column I cannot show the correct number of delayed orders done on the specific date because when I count the delayed orders it only counts the ones related to the reference date in calendar. 

For example: 

1. We are in day 1 and the order was delayed from day 1 (not done in day one as planned)
2. In day 2 it was done ( 1 day after planned)
3. If I want to display productivity I would like to show orders planned in day 2 + orders done planned previously in any day.

However, if we try to look at day 2 in the stack column it does not display the delayed order done in day 2 because the reference date was day 1. 

Measure:

Delayed produced = CALCULATE(COUNT(Productivity[Order]), Productivity[CountDelay] = 1)

Basic finish date	Order	Actual finish date	Production	When delayed done	CountDelay
14/02/2023	68583190	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523832	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523833	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523834	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523835	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523836	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523837	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523838	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523839	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523841	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68523842	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68532010	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68598514		Delayed		0
14/02/2023	68413635	14/02/2023	On time		0
14/02/2023	68606803	14/02/2023	On time		0
14/02/2023	68609505	14/02/2023	On time		0
14/02/2023	68592364	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68519478	14/02/2023	On time		0
14/02/2023	68592098	14/02/2023	On time		0
14/02/2023	68575264	14/02/2023	On time		0
14/02/2023	68598300		Delayed		0
14/02/2023	68598301	14/02/2023	On time		0
14/02/2023	68578579	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68604512	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68554444	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68558427	15/02/2023	Delayed	15/02/2023	1
14/02/2023	68594865	14/02/2023	On time		0
14/02/2023	68576134	15/02/2023	Delayed	15/02/2023	1
15/02/2023	68523843		Delayed		0
15/02/2023	68523844		Delayed		0
15/02/2023	68523845		Delayed		0
15/02/2023	68523846	16/02/2023	Delayed	16/02/2023	1
15/02/2023	68523847	16/02/2023	Delayed	16/02/2023	1
15/02/2023	68523848	15/02/2023	On time		0
15/02/2023	68523849		Delayed		0
15/02/2023	68523850		Delayed		0
15/02/2023	68523851		Delayed		0
15/02/2023	68523852		Delayed		0
15/02/2023	68523853		Delayed		0
15/02/2023	68523854	15/02/2023	On time		0
15/02/2023	68523855	15/02/2023	On time		0
15/02/2023	68523856	16/02/2023	Delayed	16/02/2023	1
15/02/2023	68585071	15/02/2023	On time		0
15/02/2023	68585760	15/02/2023	On time		0
15/02/2023	68594868	15/02/2023	On time		0
15/02/2023	68594879	15/02/2023	On time		0
15/02/2023	68594880	15/02/2023	On time		0
15/02/2023	68613855	15/02/2023	On time		0
15/02/2023	68613854	15/02/2023	On time		0
15/02/2023	68491713	15/02/2023	On time		0
15/02/2023	68491712	15/02/2023	On time		0
15/02/2023	68555682	15/02/2023	On time		0
15/02/2023	68598297	15/02/2023	On time		0
15/02/2023	68603937	15/02/2023	On time		0
14/02/2023	68618899				0
15/02/2023	68589574	15/02/2023	On time		0
15/02/2023	68589576	15/02/2023	On time		0
15/02/2023	68589578	15/02/2023	On time		0
15/02/2023	68592099		Delayed		0
15/02/2023	68607031	15/02/2023	On time		0
15/02/2023	68607032	15/02/2023	On time		0
15/02/2023	68607033	15/02/2023	On time		0

[lbendlin]

Please provide sample data that covers your issue or question completely. Please no screenshots.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Fefo]

hi, added table and measure. Thank you for the links.

[lbendlin · Accepted solution]

Here is something to get you started.  USERELATIONSHIP can activate relationships temporarily.

I don't understand your mapping logic, so you may need to do the next part yourself (or maybe explain based on an example).

[Fefo]

Thank you very much for the help. It did work and is showing what I want beautifully. 

[Fefo]

@amitchandak can you help me ?