cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
balajir98
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])))
 
Error.PNG
2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @balajir98 ,

 

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

v-yalanwu-msft_0-1621244269062.jpeg

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:

v-yalanwu-msft_1-1621244269065.jpeg

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.   

amitchandak
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

Announcements
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