How to filter calculations according to end date of slicer?

[Analitika]

Hello,

I would like to ask how to make a measure which calculates sum according to the end date of slicer. I mean when we turn left or turn right this: 

I have used this expression but it didn't help me 

filter('Date', 'Date'[Date] =maxx(allselected('Date') , 'Date'[Date])).

[v-janeyg-msft · Accepted solution]

Hi, @Analitika 

You should use all tables and save 'maxdate' as a variable first, otherwise it will be affected.

Try like this:

maxdatetotalvalue =
VAR maxdate =
    MAXX ( ALLSELECTED ( 'Table1' ), [Date] )
RETURN
    SUMX ( FILTER ( ALL ( 'Table1' ), [Date] = maxdate ), [Value] )

Below is my sample and two wrong results for reference.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[Samarth_18]

Hi @Analitika ,

I can more specifically if you could share sample data in text format with expected output.

But you can try below code:-

measure =
VAR _start_date =
    MIN ( date[date] )
VAR _end_date =
    MAX ( date[date] )
RETURN
    CALCULATE (
        SUM ( table[column] ),
        table[date] >= _start_date
            && table[date] <= _end_date
    )

Thanks,

Samarth

[Analitika]

But it didn't work.

Here is my formula.