cancel
Showing results for
Did you mean:
Frequent Visitor

## Cumulative Total only shows the last number

Hi,

I've check relationship everything but do not get what makes it wrong. I want the cumulative total for each month but this only shows the final number:

Hope anyone could clarify my confusion. Thank you

1 ACCEPTED SOLUTION
Frequent Visitor

Thanks guys. I don't really know why it does not work. But I have an alternative way. Instead of using FILTER (ALL ( ... ) etc, I will use DATESYTD like this

3 REPLIES 3
Frequent Visitor

Thanks guys. I don't really know why it does not work. But I have an alternative way. Instead of using FILTER (ALL ( ... ) etc, I will use DATESYTD like this

Super User

@yennhi95zz , I created my own sample to calculate running total and it's working fine.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
Super User

@yennhi95zz , have tried water wall visual for that

one way is

M1= SUM(Sales[Sales Amount])

M2 = CALCULATE([M1],filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))//means cumm till last month

Now if you plot these two and make m2 as white you will reach till last month

Or use M3 in place of M1

M3 =

var _max = maxx(allselected('Date') ,'Date' [Date]))

return

if( max('Date' [Date]) = _max,  CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date])))  , [M1] )

Cumm on M1 in last month

M4 =

var _max = maxx(allselected('Date') ,'Date' [Date]))

return

if( max('Date' [Date]) = _max, blank(), [M2])

use M3 and M4 in visual with m4 as white and try

Dashboard of My Blogs !! Connect on Linkedin

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

#### Launching new user group features

Learn how to create your own user groups today!