topic Re: Cumulative Sum is not giving correct results in DAX Commands and Tips

Cumulative Sum is not giving correct results

talkprem — Fri, 13 Oct 2023 09:24:54 GMT

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

Re: Cumulative Sum is not giving correct results

PurpleGate — Fri, 13 Oct 2023 09:56:53 GMT

Try

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

Re: Cumulative Sum is not giving correct results

talkprem — Fri, 13 Oct 2023 10:06:56 GMT

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

Re: Cumulative Sum is not giving correct results

PurpleGate — Fri, 13 Oct 2023 10:49:47 GMT

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

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

Re: Cumulative Sum is not giving correct results

talkprem — Fri, 13 Oct 2023 12:19:40 GMT

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.