Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
talkprem
Helper I
Helper I

Cumulative Sum is not giving correct results

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)

PJ_20231013_142814674~2.jpg

 

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 

4 REPLIES 4
PurpleGate
Resolver III
Resolver III

Try

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

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

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

 

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

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors