How to have a total sum of the cumulative sums of a measure?

[rodrigonogueir4]

Hello guys,

Basically I need a TOTAL that is actually a SUM of the CUMULATIVE SUM of a measure I made.

As you can see in the table above the TOTAL is actually the last value I have, I understand the reason for this and I know that this is the correct total but for the purpose I need I have to add up all the values for each month, no it needs to be in this total field of the table actually for me it would be even better to put the TOTAL on a card.

Cumulative by Month = Calculate(Count('resources'[id]), FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) * Calculate(COUNT(order[id])* MIN(Costs[Cost]), Filter(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])))

[amitchandak · Accepted solution]

@rodrigonogueir4 , Try like

sumx(Values('Calendar'[month year]) ,Cumulative by Month = Calculate(Count('resources'[id]), FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) * Calculate(COUNT(order[id])* MIN(Costs[Cost]), Filter(ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]))) )