Cumulative Sum of Another Measure

[mybarbie9917_LI]

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, 

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. 

Sample File 

[Dangar332 · Accepted solution]

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]

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])
        )
     )

[mybarbie9917_LI]

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.