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

rodrigonogueir4 — Thu, 10 Mar 2022 16:48:27 GMT

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])))

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

amitchandak — Thu, 10 Mar 2022 18:10:23 GMT

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]))) )

topic Re: How to have a total sum of the cumulative sums of a measure? in DAX Commands and Tips

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

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