Cumul with filter date

[Fabi]

Hi all !

I have a report like this :

I would like that, when I select a year in the filter, it sums the selected year and all the previous years.

Exemple : if I select 2021 in the filter, I should therefore have A = 4, B = 11 and C = 14. If I select 2022: A = 6, B = 15, C = 20.

I tried with several calculations (CALCULATE, SELECTEDVALUES, ALL, etc.) but I didn't succeed, using the dates filter always breaks everything.

If anyone has an idea that would be great because I'm really stuck... Thank you 

[Fabi]

Thanks @FreemanZ  and @Jihwan_Kim ,

The solution of @Jihwan_Kim work simply.

In my real data, I was working with a date field and it didn't work. I had to extract in another column the year and use this one for it to work.

Thanks !

[FreemanZ]

Supposing your table named Data, try to plot the measure with the code below:

Measure := 

VAR _year =

    SELECTEDVALUE ( Data[Year])

VAR _Result =

CALCULATE (

    SUM(Data[inscriptions]),

    Data[Year]<=_year

)

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected measure: =
CALCULATE ( SUM ( Data[Value] ), 'Year'[Year] <= MAX ( 'Year'[Year] ) )