Trying to calculate cumulative total displayed month over month based on status each month for chart

[BBHWicked94]

I need a formula to check during a selected date range to determine what the latest status (based on closed and action date) was for the number and year/month group for that snapshot of the month. If the date range changes, that number being counted is subject to change as well. For example, if group was added to a number in June but was closed in July, you would see that accounted for in June but not July. Essentially, a cumulative snapshot of each month with total from prior months based on status at the time in the chart.

Here's what I've come up with but the chart is blank when I add the measure by year/month

VAR SelectedVal=SELECTEDVALUE('Party'[Action Date])

RETURN

CALCULATE(

    DISTINCTCOUNT('Party'[Number]),

    FILTER(

        ALLSELECTED('Party'[YearMonth]), SELECTEDVALUE(Closed[CLOSE])>SelectedVal&&

        ISONORAFTER('Party'[YearMonth], MAX('Party'[YearMonth]), DESC)

    )

)

Sample Data: 

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...