Monthly cumulative running total continuation

[dmc2020]

I am trying to figure out a measure to calulcate how many to date are "currenlty open overdue" e.g June should be showing 11 open overdue by including and calculating all the previous months that are still open overdue. Need the line to show whether the total open overdue is getting better or worse each month.

This is the measure i have just now but it's only calculating for that month and not including previous. 

OpenAndOverdueCount =

IF(

    ISBLANK(

        CALCULATE(

            COUNTROWS('Merged Deviations'),

            'Merged Deviations'[Status] = "open",

            'Merged Deviations'[Upcoming Days] > 0

        )

    ),

    0,

    CALCULATE(

        COUNTROWS('Merged Deviations'),

        'Merged Deviations'[Status] = "open",

        'Merged Deviations'[Upcoming Days] > 0

    )

)

[amitchandak]

@dmc2020 , Hope you are using date table joined with date of your table

OpenAndOverdueCount = = CALCULATE(
COUNTROWS('Merged Deviations'),
'Merged Deviations'[Status] = "open",
'Merged Deviations'[Upcoming Days] > 0
)


OpenAndOverdueCount Cumm = calculate([OpenAndOverdueCount], filter(Date, Date[Date] <= Max(Date[Date])) )

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.