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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mybarbie9917_LI
New Member

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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