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
TheProv
Frequent Visitor

Filter just visual and not running total measure

Hi everyone.
So, I have a nice running total measure to measure daily subscribers, tied to my date table. If I add a slicer filter to focus on a certain period however the running total will change, because the measure will ignore the results earlier than the lower date filter.
Is there a way to ignore the filter just for the measure calculation and apply it to the visual?
I avoided creating a second table with the totals because with the measure I keep relations that I can use for advanced visuals.

TheProv_0-1671812199888.png

Subscriptions running total = 
CALCULATE(
    SUM('Users subscriptions history'[Sub Balance]),
    FILTER( ALLSELECTED('Date'[Date]),
    ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)
    )
)

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @TheProv 

just replace ALLSELECTED with ALL

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @TheProv 

just replace ALLSELECTED with ALL

Greg_Deckler
Community Champion
Community Champion

@TheProv Would have to know your measure formula for your running total. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

You're right, sorry:

Subscriptions running total = 
CALCULATE(
    SUM('Users subscriptions history'[Sub Balance]),
    FILTER( ALLSELECTED('Date'[Date]),
    ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC)
    )
)

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.