# Cumulative total gives me same result as monthly total even though changed the formula

I have two formulas that give me the same result. The result I am getting is the monthly total.
This formula correctly gives me only the ABC subscriptions added in the current month:

ABCs Started =
CALCULATE (
[ABC Order Count All],
USERELATIONSHIP(‘Recurring Subscriptions’[Subscription Start Date],DateTable[Date]),
FILTER (
values(‘Recurring Subscriptions’[Subscription Start Date]),‘Recurring Subscriptions’[Subscription Start Date]<=max(DateTable[Date])),
FILTER (
values(‘Recurring Subscriptions’[Subscription Start Date]),‘Recurring Subscriptions’[Subscription Start Date]>=MIN(DateTable[Date]))
)

This formula is trying to get the cumulative total but it gives me the monthly total only.
ABCs Cumulative Started To Date =
CALCULATE (
[ABC Order Count All],
USERELATIONSHIP(‘Recurring Subscriptions’[Subscription Start Date],DateTable[Date]),
FILTER (
all(‘Recurring Subscriptions’[Subscription Start Date]),‘Recurring Subscriptions’[Subscription Start Date]<=max(DateTable[Date])

``````))
``````

Note, I need to use USERELATIONSHIP because I have another calculation that needs to use the END DATE. Both of these work fine to count the users that started and ended in the month. The problem is when I try to get the cumulative, it only gives me the total for the month.

Hello @ScottTPA,

For Cumulative Totals instead of selecting “ALL” replace it with “ALLSELECTED” and also replace the ‘Recurring Subscriptions’[Subscription Start Date]) with the Dates Table. So your code should be like this overall -

``````ABCs Cumulative Started To Date =
CALCULATE ( [ABC Order Count All] ,
USERELATIONSHIP( ‘Recurring Subscriptions’[Subscription Start Date] , DateTable[Date]) ,
FILTER ( ALLSELECTED ( DateTable ) ,
DateTable[Date] <= MAX( DateTable[Date] ) ) )
``````

Also for calculation of Current Month Total you could have also used DATESMTD which could be -

``````ABCs Started =
CALCULATE ( [ABC Order Count All] ,
USERELATIONSHIP( ‘Recurring Subscriptions’[Subscription Start Date] , DateTable[Date]) ,
DATESMTD( DateTable[Date] ) )
``````

I’ve also attached the screenshot and file of my working indicating both the steps i.e. wrong one and the correct one for Cumulative Totals.