Cumulative Sum Measure

[Anonymous]

Hi,

I've made below measure for Cumulative Sales. However I want it slightly different so that when I select for example Months 7, 8 and 9, it only shows cumulative sales as from Month 7 on. So, not showing values € 28.814.316,37 (Month 7), € 30.580.458,70 (Month 8), € 33.891.502,57 (Month 9) but values € 3.315.379,87 (Month 7), € 5.081.522,20 (Month 8 -->  € 3.315.379,87 + € 1.766.142,33) and € 8.392.566,07 (Month 9 --> € 5.081.522,20 + € 3.311.043,87). 

Does someone have an idea how to change the measure?

Thanks in advance!

*Net Sales Cumulative =

CALCULATE (

    [Net Sales],

    FILTER (

        ALL ('Invoice Date'),

        'Invoice Date'[DateFull] <= MAX ('Invoice Date'[DateFull])

            && 'Invoice Date'[YearId] = MAX ('Invoice Date'[YearId])

    )

)

[Anonymous]

@Greg_Deckler Thank you! 

I want to use this cumulative measure in another measure as mentioned below (the idea is to switch to cumulative values (VAR _Cumulative) when more than 1 month is selected. If only 1 month is selected, it needs to show the Net Sales(=SUM(Sales[SalesAmount])). However, it does not work properly. Do you have an idea how it might work?

*Net Sales VAR =

VAR _Count = COUNTROWS(VALUES('Invoice Date'[MonthInYear]))

VAR _Cumulative = 

CALCULATE (

    [Net Sales],

    FILTER (

        ALLSELECTED ('Invoice Date'),

        'Invoice Date'[DateFull] <= MAX ('Invoice Date'[DateFull])

            && 'Invoice Date'[YearId] = MAX ('Invoice Date'[YearId])

    )

)

RETURN

IF(_Count=1, [Net Sales], _Cumulative)

[Greg_Deckler · Accepted solution]

@Anonymous Should be able to use something along the lines of IF(COUNTROWS(ALLSELECTED('Table')) = 1, <net sales goes here>, <cumulative measure goes here>)

[Greg_Deckler]

@Anonymous Try using ALLSELECTED vs. ALL