Running total Error

[balajir98]

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])))

[v-yalanwu-msft]

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.   

[amitchandak]

@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