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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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