Cumulative Total in Card

Question

Hi All,I would like to show the cumulative total waste in card for the month selected in the slicer. I already the cumulative(running total) working in a table, but in a card it only shows the current month. I've tried DATESYTD but it doesn't work, thanks.&nbsp;(correct) # Total Waste =&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE (SUM('Metric'[Numeric Value])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,'Metric Name'[MetricName] =&nbsp; "Total General Waste recycled"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CALCULATE (SUM('Metric'[Numeric Value])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,'Metric Name'[MetricName] =&nbsp; "Total General Waste sent to landfill"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;(correct) # Total Waste Running Total =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [# Total Waste],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Previous Date',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Previous Date'[Month],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'Previous Date'[Month Short Name]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED('Previous Date')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISONORAFTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Previous Date'[Month], MAX('Previous Date'[Month]), DESC,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Previous Date'[Month Short Name], MAX('Previous Date'[Month Short Name]), DESC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;&nbsp; &nbsp;Card measure attempt:&nbsp;&nbsp; &nbsp;CALCULATE (SUM('Metric'[Numeric Value])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,'Metric Name'[MetricName] =&nbsp; "Total General Waste recycled"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,DATESYTD('Calendar'[Date])&nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp;+&nbsp; &nbsp; &nbsp;CALCULATE (SUM('Metric'[Numeric Value])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,'Metric Name'[MetricName] =&nbsp; "Total General Waste sent to landfill"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,DATESYTD('Calendar'[Date])&nbsp; &nbsp; &nbsp; )&nbsp;Selected April in card should be 124.2 + 65.4Hope this clear and thanks for any assistance.&nbsp;

v-xiaosun-msft · Accepted Answer

Hi&nbsp;ringovski&nbsp;,
According to your description, here is my solution.
I created a sample directly from the “Month Short Name” and “Total Waste” you gave.

Create a DATE table and put it into slicer. Note that the relationship between the two dates should be established.

&nbsp;

Create a measure and put it into a card.
Numeric Value =
CALCULATE (
    SUM ( 'Table'[Total Waste] ),
    DATESYTD ( 'Table'[Month Short Name] )
)
Select the month you need and you will get the final output:

&nbsp;
Best Regards,Community Support Team _ xiaosun
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Cumulative Total in Card

2 Replies

Related content

Cumulative Total

Cumulative Total

SumX? - cumulative running total

Cumulative Total

Cumulative total