Running total help

[sabinocivita]

Hi everyone, I have these data for this year. First column 'Mese' is month and second one 'Dossier' is a distinct count coming from the data set. 'Mese' is month hierarchy from field DATASTAT of table DUNDASSTAT. 

I filtered for 2022 year and I create this measure

RTDossier1 = CALCULATE(DISTINCTCOUNT(DUNDASSTAT[DOSSIER]);FILTER(ALL(DUNDASSTAT[DATASTAT].[Mese]);DUNDASSTAT[DATASTAT].[Mese] <=MAX(DUNDASSTAT[DATASTAT].[Mese])))

But it doesn't work. It gives me same data, not running total month after month. What is wrong?

Thanks for your help.

PS: I made measure for yearly running total and it works (taking last for years). Here below the measure

RTDossierA = CALCULATE(DISTINCTCOUNT(DUNDASSTAT[DOSSIER]);FILTER(ALL(DUNDASSTAT[DATASTAT].[Anno]);DUNDASSTAT[DATASTAT].[Anno] <=MAX(DUNDASSTAT[DATASTAT].[Anno])))

[amitchandak]

@sabinocivita , if you have the date, best it to have a date table have a measure like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

if data is at month level prefer YYYYMM format month or sortable month in a separate table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(month),month[month ] <=max(month[month])))

[sabinocivita]

@amitchandak sorry, but it's not clear. I'll explain better. I have a source table DUNDASSTAT. Then a date field called DATASTAT. I have a field DOSSIER. So maybe I have first to convert month name in a numeric month?