cancel
Showing results for
Did you mean:
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 !!

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.

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

Thank you very much,

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?

Proud to be a Datanaut!

Highlighted
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...

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.

Best regards,

DM

Announcements

#### Challenge: Can You Solve These?

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

#### Community News & Announcements

Get your latest community news and announcements.

#### 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.

#### Win Power BI Swag with Community Kudopalooza!

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

Top Kudoed Authors
Users Online
Currently online: 47 members 979 guests
Recent signins: