Cumulative value error

[AlanP514]

Hai, I had created cumulative but in between, it showed wrong values
you can see if we add 202 + 18 = 220(Actual) But I am getting 214 I am confused why this is showing in this way
And  the second error is the sales total is shown below and my cumulative total is shown in the top 
How I can solve these two issues Please help me 

And this is the dax i had used

sales Cumulative =
CALCULATE (
[sales],
DATES BETWEEN (
'Calendar'[Date],
NEXTDAY ( SAMEPERIODLASTYEAR ( LASTDATE ( 'Calendar'[Date] ) ) ),
LASTDATE ( 'Calendar'[Date] )
)
)

[v-zhangti · Accepted solution]

Hi, @AlanP514 

You can try the following methods.

Sales Cumulative =
CALCULATE (
    [Sales],
    FILTER (
        ALL ( 'Table' ),
        [Year Month] <= SELECTEDVALUE ( 'Table'[Year Month] )
    )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlanP514]

Hai,Your solution really helped me i will accept as a solution,
can you help me to solve this requirement
https://community.powerbi.com/t5/Desktop/Converting-static-to-Dynamic-Measure/m-p/2550780

[ddpl]

Try this:

Step 1: Create Measure

Cumulative Total =
CALCULATE (
SUM ( 'Table'[Sales] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
)

Accept as solution if its worked.