Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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]...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous ,

 

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.