Average days running calculated for each date context

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached file.

Expected measure: =
VAR _newtable =
    ADDCOLUMNS (
        Data,
        "@Day running",
            IF (
                Data[Date closed] <> BLANK (),
                DATEDIFF ( Data[Date created], Data[Date closed], DAY ),
                DATEDIFF ( Data[Date created], TODAY (), DAY )
            )
    )
VAR _filternewtable =
    FILTER (
        _newtable,
        Data[Date closed] >= MIN ( 'Calendar'[Date] )
            && Data[Date created] <= MAX ( 'Calendar'[Date] )
    )
RETURN
    IF (
        HASONEVALUE ( 'Calendar'[Month name] ),
        AVERAGEX ( _filternewtable, [@Day running] )
    )