Cumulative starting with sum of that data

[PrinceII]

When I  select a period I would like to see that the cumulative starts with the cumulative of that date (and not starting at 0) when selected a date

[ValtteriN · Accepted solution]

Hi,

This can be achieved by using ALL.

My test data:

Data model:

Measure:

RunningTotal YTD = CALCULATE(SUM(Cumulativetotal[Value]),all(Cumulativetotal[Date]),DATESYTD(Cumulativetotal[Date]))

End result:

Note that eventhought my selection begins from april the cumulative calculation starts from 11

Hope this helps to solve your issue and if it does consider accepting this as a solution!