YTD Running Totals based on current visual table

[Anonymous]

Hello,

I have a table with Months as its first column and a score value as the second column.

The score is a complex measure that is calculated from various measures and tables. It is not a figure in a specific table.

I don't seem to get it right for creating a YTD running total of that measure.

I tried:

Overall Performance YTD = 
CALCULATE (
    SUMX ( VALUES ( dimCalendar[MonthYear] ), [Overall Performance] ),
    FILTER (
        ALLSELECTED ( dimCalendar[MonthYear] ),
        dimCalendar[MonthYear] <= MAX ( dimCalendar[MonthYear] )
    )
)

 The result should be :[20,44,68...etc]

Please find a link to a demo table.

Demo Table

Thank you,

Tamir

[v-jiascu-msft]

Hi @Anonymous,

I didn't see anything you described here in the demo. Can you check the demo file, please? Seems the result is right in the demo.

Best Regards,
Dale