Slicer to see the running total value for specific filter selection (Year QTR)

[rajaurora]

I have year qtr and running count for years based head count . I just want to filter using the slicer and get the running total value for a specific qtr for a year

I have created the running total count based on
Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALLSELECTED(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)

I have year qtr and total in the table when I tried to filter say 2021 Q1 i would like to see the running total all the way to 2021 Q1 instead of just the count for the specific quarter
if anyone has better solution  to achieve this please share

[rajaurora]

Thank you so much it worked great ..Awesome 

[Fowmy · Accepted solution]

@rajaurora 

Try this please:

Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALL(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)