cancel
Showing results for
Did you mean:

## Stopping Cumulative Total

Hi everyone, how can I stop my cumulative total on calculating when no actual values on subsequent days/months. I do have my date filtered in Year. Thanks in advance.

Here are my two measures respectively:

``````Bank Movements (Cummulative) = [Op Bal Interim Bank Transactions] +
CALCULATE(
[Bank Movement] ,
FILTER(
ALLSELECTED( Dates),
Dates[Date] <= MAX( Dates[Date])
)
)``````

``````Bank Movements (Cumulative) New Measure =
IF (
SELECTEDVALUE ( Dates[Date] ) > [Last Sales Date],
BLANK (),
CALCULATE (
[Bank Movement],
FILTER ( ALLSELECTED ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) )
)
) + [Op Bal Interim Bank Transactions]
``````

1 ACCEPTED SOLUTION
Super User

@ronaldbalza2023 , hope in this measure you have not added +0 or handled blank value using if

Op Bal Interim Bank Transactions

remove +0 or any blank handling

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
3 REPLIES 3
Super User

@ronaldbalza2023 , Try a new measure like

Bank Movements (Cumulative) New Measure =
var _max = maxx(allselected(Dates),Dates[Date])
return
CALCULATE (
[Bank Movement],
FILTER ( ALLSELECTED ( Dates ), Dates[Date] <= MAX ( Dates[Date] ) && Dates[Date] <=_max )
)
+ [Op Bal Interim Bank Transactions]

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Hi @amitchandak, It did the same thing as on my two measures. Was it because of my filter?

Super User

@ronaldbalza2023 , hope in this measure you have not added +0 or handled blank value using if

Op Bal Interim Bank Transactions

remove +0 or any blank handling

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Announcements