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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mybarbie9917_LI
Regular Visitor

Cumulative Sum of Another Measure

I have a small task that I find hard to accomplish as I always find DAX so difficult. I need to create measure to calculate the cumulative sum of another measure. For example, 

mybarbie9917_LI_1-1699509682234.png

 

mybarbie9917_LI_0-1699509658582.png

The column Cumulative Sum of "Sales Check" is what I am looking for, so I can tell November is the 6th month in the 2009 year that had the cumulative sales greater than $25M. I hope someone can please show me a solution. 

 

mybarbie9917_LI_2-1699509727855.png

 

Sample File 

1 ACCEPTED SOLUTION
Dangar332
Super User
Super User

hi, @mybarbie9917_LI 

try below

sales cumulative =
     calculate(
        sumx('tablename',[sales check]),
        filter(
           all('d_date'),
           'd_date'[month]<= max('d_date'[month])&&
            d_date'[year]=max(d_date'[year])
        )
     )

View solution in original post

3 REPLIES 3
Dangar332
Super User
Super User

hi, @mybarbie9917_LI 

try below

sales cumulative =
     calculate(
        sumx('tablename',[sales check]),
        filter(
           all('d_date'),
           'd_date'[month]<= max('d_date'[month])&&
            d_date'[year]=max(d_date'[year])
        )
     )
Dangar332
Super User
Super User

HI, @mybarbie9917_LI 

if you want to use MEASURE  inside sum use sumx() instead of sum()
try below

sales cumulative =
     calculate(
        sumx('tablename',[sales amount]),
        filter(
           all('d_date'),
           'd_date'[Date]< max('d_date'[Date])
        )
     )

Thanks for your reply, but it is not exactly what I am looking for. I already have the Sales Cumulative measure. I want to have measure that can do the cumulative sum from the result of the measure Sales Check. 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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