Power Bi - metric not filtering correctly

[Ines_Raquel]

Hello.

What i intend is to have an accumulate that sums all years that are equal or inferior to the selected year. For instance, if  i select 2021, then i want to count all years that come before 2021 plus 2021 itself.

The problem is that the metric i created is filtering only the year selected, not the previous years as well.

This is an example formula for the intended logic:

NumEmp_2021:=
calculate(DISTINCTCOUNT('fact table'[NIF]),
filter('Fact table',
year('Fact table'[Employment Date]) <= 2021
&& ('Fact table'[Resignation Date] = BLANK() || (year('fact table'[Resignation Date]) >=2021))))

How can i adapt this to select the filtered year plus all the years that come before that?

Thanks in advance

[Greg_Deckler]

@Ines_Raquel Try: Better Running Total - Microsoft Power BI Community