Count Records Between Start date/time and End date/time (for every second of the day(s))

[AndreasB]

Hi,
I need some help with a formula in DAX for a measure.

data:

_id	Start Date/Time	End Date/Time
63c13320c47798de09659e2c	13.01.2023 10:19:08	13.01.2023 10:19:31
63c13320c47798de09659d09	13.01.2023 10:20:18	13.01.2023 10:20:52
63c13320c47798de09659d1f	13.01.2023 10:23:28	13.01.2023 10:24:54
63c13320c47798de09659d20	13.01.2023 10:19:20	13.01.2023 10:20:10
63c13320c47798de09659d35	13.01.2023 10:18:35	13.01.2023 10:19:15
63c13320c47798de09659db9	13.01.2023 10:18:22	13.01.2023 10:19:54
63c13320c47798de09659de8	13.01.2023 10:19:30	13.01.2023 10:20:00
63c13320c47798de09659e09	13.01.2023 10:20:01	13.01.2023 10:20:26
63c13320c47798de09659cbc	13.01.2023 10:20:40	13.01.2023 10:26:45

And I have a date/time table (similar to a date table but with a record per second instead of a record per day):
[D/Ts]

date/time

13.01.2023 10:19:16

13.01.2023 10:19:17

13.01.2023 10:19:18

13.01.2023 10:19:19

13.01.2023 10:19:20

13.01.2023 10:19:21

13.01.2023 10:19:22

13.01.2023 10:19:23

13.01.2023 10:19:24

What I'd need is a measure for each [D/Ts].'date/time' that count([data].'id') where [D/Ts].'date/time' >= [data].'Start date/time' AND [D/Ts].'date/time' <= [data].'End date/time':

date/time	required result
13.01.2023 10:19:16	2
13.01.2023 10:19:17	2
13.01.2023 10:19:18	2
13.01.2023 10:19:19	2
13.01.2023 10:19:20	3
13.01.2023 10:19:21	3
13.01.2023 10:19:22	3
13.01.2023 10:19:23	3
13.01.2023 10:19:24	3

Thanks in advance for any help getting this solved.

[AndreasB]

Thanks a lot @wdx223_Daniel  - this was exactly what I was trying to do. 

[wdx223_Daniel · Accepted solution]

NewMeasure=VAR _Second=MAX('D/Ts'[date/time]) RETURN COUNTROWS(FILTER(Data,Data[Start Date/Time]<=_Second&&Data[End Date/Time]>=_Second))