Accumulative selection slicer

[maserr]

Hi there,

I have a a month slicer which I would desire the following behaviour:

for default, I would want a multiselection until the month I had chosen. If I want February, the slicer showing January and February. That way my value could be accumulative to the month and would not need YTD. I would also want to obtain the monthly value so I could unmark January. Would this be possible in order not to do it manually?

Thanks

[v-xicai · Accepted solution]

Hi @maserr ,

You may create measure like DAX below.

Cumulative Total =
CALCULATE (
    SUM ( Table1[sale] ),
    FILTER (
        ALLSELECTED ( Table1 ),
        YEAR ( Table1[Date] ) = YEAR ( MAX ( Table1[Date] ) )
            && MONTH ( Table1[Date] ) <= MONTH ( MAX ( Table1[Date] ) )
    )
)

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@maserr , With a date table, try like

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date])))

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=maxx(date,date[date])))

Month filter should come from date table

[maserr]

Sorry, I may not explained myself. I would need this slicers:

Can I build with DAX function that the multiselection behaves dinamically selecting the month before the one chosen? In order to have the information accumulative.