Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Running total Error

I am trying to put running total based on date, i am getting error for the below calculation,

#RT = CALCULATE(SUM(Day_Wise[Day Expenses]),FILTER(ALLSELECTED(Day_Wise),Day_Wise[Transactions_#R_Date]<=MAX(Day_Wise[Transactions_#R_Date])))
Community Support
Community Support

Hi, @balajir98 ,


I have tried to calculate with your measure and it is correct. It returns the following results:


If the result is your image appears, May be only uses ALLSELECTED(Day_Wise), For example:

error total = CALCULATE(SUM(Day_Wise[Day Expenses]),ALLSELECTED(Day_Wise))

and it will appear this image:


If that doesn't solve your problem, can you share me with pbix file after removing sensitive data.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.   

Super User IV
Super User IV

@balajir98 , This formula seems correct, are these Qtr, month and day are part of this date Transactions_#R_Date

or some other date ?

Add year and check.

But I doubt date only

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors