Cumulative Sum is not giving correct results

[talkprem]

Hello,

I am currently trying to get cumulative sum of my sample data as in picture. but instead of Cumulative Variance and Cumulative Sales i am getting same as the normal variance and Cumulative sales. I have pasted my DAX code as well but it is not working.
I have slicers on datetime,pharmaid,base,base group (currently only datetime and pharma id are selected)

This is the dax formaula used for Cumulative variance and Sales - 

Cumulated Variance =
CALCULATE (
SUM (Table1'[Variance]),
FILTER(ALLSELECTED(Table1[DateTime],Table1[pharmaSiteld]),
 Table1[DateTime] <=MAX(Table1[DateTime])
)

Can someone please help me 

[PurpleGate]

Try

CALCULATE(
    COUNTA('Table1'[Variance]),
    FILTER(
        ALLSELECTED('Table1'[DateTime]),
        ISONORAFTER('Table1'[DateTime], MAX('Table1'[DateTime]), DESC)
    )
)

[talkprem]

This is Giving all rows as 1 in cumulative sum. Can you please try once more?

[PurpleGate]

Ok, I guess you should use Sum instead of Count. 

Or if your Variance column is already a measure, then just use that instead.

[talkprem]

Yes i have already given my DAX formula, but it is not giving the cumulative sum i need. can someone please help on this.
I have been trying for 2 days and still got no solution.
Instead of cumulative sum i am getting same value as variance column.