Running total of selected months

[bsheffer]

What I want is like a running total in a visual with a legend of year and an axis of months.  The user picks the months they want from a page filter and for each month that appears I want to show the total of that month and all the previously appearing months.

so if I choose March, June, and september from the filter, only 3 months appear in the visual.  I want march to show just the total for that month.  June shows the total of both March and June.  September shows the total of March, June & September.

this is only if the user chooses a selection of months.  If the user doesn't use the filter or chooses all 12 months in a year, I want it to show the standard running total.

the two visuals are identical except for the _measure in the values field

here is the page filter

both the page filter and the visual axis are using the same field, so getting a count of the number of distinct values selected in the filter is difficult for me since the visual restricted it to just one monthly value

the monthy values are 

Month mmm	Year	_Total_Partner_Payment
Jan	2021	10938
Feb	2021	9962
Mar	2021	-22864
Apr	2021	1571
May	2021	3763
Jun	2021	2409
Jul	2021	7089
Aug	2021	2309
Sep	2021	3307
Oct	2021	4573
Nov	2021	0

so march should show -22864

    june should show -20455 (-22864 + 2409)

   sep should show -17148  (-22864 + 2409 + 3307)

as contrasted to the normal running totals

Month mmm	Year	_running_total_Partner_Payment
Jan	2021	10938
Feb	2021	20900
Mar	2021	-1963
Apr	2021	-392
May	2021	3370
Jun	2021	5779
Jul	2021	12868
Aug	2021	15177
Sep	2021	18483
Oct	2021	23056
Nov	2021	23056

Ideally I would have the ability to test for the number of months selected.  (0 or 12 would use the standard running total and any number of months between 1 to 11 would just total the selected months on or before that month on the visual for that year.

here are my current measures

_running_total_Partner_Payment =

var _year = max('Dim Calendar ActivityMonth'[Year])

var _month= max('Dim Calendar ActivityMonth'[MonthNo])

return

if(ISBLANK([_Total_Partner_Payment]), BLANK(),

CALCULATE('Fact Cubes'[_Total_Partner_Payment],

year('Dim Calendar ActivityMonth'[Date])= _year,

month('Dim Calendar ActivityMonth'[Date])<= _month

)

)

_Total_Partner_Payment = sum('Fact Cubes'[Total_Partner_Payment])

[VijayP · Accepted solution]

@bsheffer 
I think you want this way ! attached the pbix file 

[bsheffer]

thanks for your help.  Here is my modified measure.  My changes in bold.  The key was using the allselected function.  It ignored the implicit month filter in the visual while still respecting the month page filter values.

_running_total_Partner_Payment =

var _year = max('Dim Calendar ActivityMonth'[Year])

var _month= max('Dim Calendar ActivityMonth'[MonthNo])

var _months_selected = calculatetable(VALUES('Dim Calendar ActivityMonth'[MonthNo]), allselected('Dim Calendar ActivityMonth'))

return

if(ISBLANK([_Total_Partner_Payment]), BLANK(),

CALCULATE('Fact Cubes'[_Total_Partner_Payment],

year('Dim Calendar ActivityMonth'[Date])= _year,

month('Dim Calendar ActivityMonth'[Date])<= _month

,month('Dim Calendar ActivityMonth'[Date]) in _months_selected

)

)