Forum Discussion

MH3's avatar
MH3
Helper V
6 years ago

Commulative Total Not Working or Broken

Hello, I have a Measure for Revenue, and I was trying to calculate the Commulative Total, but it's not displaying correct values. as the formula for the Commulative total I used is: Cummulative =...
Need Help
Show and Tell
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi MH3 ,

 

We can use the following measure to meet your requirement.

 

Cummulative = 
CALCULATE(
            SUMX(VALUES('Calendar'[Date]),'Sales'[Measure revenue]),
            FILTER(
                        ALLSELECTED('Calendar'),
            'Calendar'[Date] <= Max('Calendar'[Date])))

 

Then result like this,

 

 

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.