Filter based on date range in another table

Hi Anonymous ,

We can create a calculated table contain all the possible date first (ignore this step if you already have such one):

DateTable =
CALENDAR ( MIN ( 'Table'[Created Date] ), MAX ( 'Table'[Closed Date] ) )

Then we create a measure to count the number:

BugsCount = 
SUMX (
    'Table',
    COUNTX (
        FILTERS ( 'DateTable'[Date] ),
        IF (
            [Date] >= 'Table'[Created Date]
                && [Date] <= 'Table'[Closed Date],
            1,
            BLANK ()
        )
    )
)

Or

BugsCount =
COUNTX (
    'Table',
    IF (
        SELECTEDVALUE ( 'DateTable'[Date] ) >= 'Table'[Created Date]
            && SELECTEDVALUE ( 'DateTable'[Date] ) <= 'Table'[Closed Date],
        1,
        BLANK ()
    )
)

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.