DAX measures to solve a Running Total problem

[hcova]

Dear sirs:

Please your help with the following problem that I can not solve yet. Any help is welcome


I have the following Excel pivot table:





This Pivot Table is build from the following table called "Systems"







I add a Calendar Table into the model too









Following with the above Pivot Table picture, I have tried to write the below DAX measure to calculate the Running Total values (Column E in the above Pivot Table) related with column "Total".



As you can see in the above Pivot Table the RTotal DAX measure applied in column E didn't work well.












So what do I need???

1 ) I would like ask you about DAX measures the get the columns "Yearly RTotal" (accumulates the year results of "Total" only) and "AllTime RTotal" (accumulates the entire pivot table results of "Total") in the below Pivot Table







2) Moreover I need that these DAX measures work well when I try to filter by "Year" column too.

For example, if I filter for 2022 and 2023 years, I would like to get the following Pivot Table

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Redirecting

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.