Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rajaurora
Frequent Visitor

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

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_0-1625755968230.png

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@rajaurora 

Try this please:

Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALL(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
rajaurora
Frequent Visitor

Thank you so much it worked great ..Awesome 

Fowmy
Super User
Super User

@rajaurora 

Try this please:

Running Total Count =
CALCULATE(
[TOTAL COUNT],
FILTER(
ALL(‘All’[Year QTR]),
ISONORAFTER(‘All’[Year QTR], MAX(‘All’[Year QTR]), DESC)
)
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.