cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yennhi95zz
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:

 

yennhi95zz_0-1628578570600.png

 

yennhi95zz_1-1628578617479.png

 

Hope anyone could clarify my confusion. Thank you

1 ACCEPTED SOLUTION
yennhi95zz
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 

yennhi95zz_0-1628597709065.png

 

View solution in original post

3 REPLIES 3
yennhi95zz
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 

yennhi95zz_0-1628597709065.png

 

View solution in original post

Tahreem24
Super User
Super User

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

Capture.JPG

 

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
amitchandak
Super User
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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
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!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!