cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DM_BI Member
Member

Re: Cumulative value using slicer and not summing values of the same month of different years

Oh ok I didn't know it was possible, thank you. Actually I don't need to do it because we are used to building reports in terms of academic years. 

I put the right start and end dates to my months so now my graph is now ok !!

Captura cumulative value 3.PNG

 

But I have a second problem : when I use the slicer of academic years, I have a wrong result for "2018/2019"... I have the total of the year 2017/2018 PLUS the value of november 2018. But what I want when I filter by 2018/2019 is to come back to zero (because it's a new year) and not to sum with what have been done last year.

 

Captura cumulative value 4.PNG

Do you where the problem can come from? Is is possible?

 

Thank you very much,

Stachu Super Contributor
Super Contributor

Re: Cumulative value using slicer and not summing values of the same month of different years

can you share sample anonymised data and the syntax of the measure you're using?

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
DM_BI Member
Member

Re: Cumulative value using slicer and not summing values of the same month of different years

Hello,

 

Here is a sample where I reproduced whaat I'm doing. What is weird is that in the sample I can't get the cumulative total when it's the same formula... The idea is create a measure (named cumulative total) that gives the cumulative facturation by month, and when I filter by year, the graph shouldn't sum the facturation of the last  year but start a new calculation of cumulative total. 

Tell me if I'm not clear.

 

Thank you very much for your time.

 

https://gplaneta-my.sharepoint.com/:u:/g/personal/udm06a_psoplaneta_com/EUk1XfqMUX5BmVRUi3ZeDksBVraH...

DM_BI Member
Member

Re: Cumulative value using slicer and not summing values of the same month of different years

I think I've found the solution. We have to use ALLSELECTED instead of ALL because ALLSELECTED retains the filters. For me it works perfectly with this formula : 

Cumulative Total = CALCULATE(SUM('MAT 18+19'[FACTURACIÓN NETA]);FILTER(ALLSELECTED(DimDate);'DimDate'[Date] <= MAX('DimDate'[Date]))
 
I hope it can help other people. Smiley Happy
 
Best regards,
 
DM

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 979 guests
Please welcome our newest community members: