Get the Amount before the selected start date in the slicer

[Anonymous]

Hi,

    I have a report where there will be a date slicer, I want to sumup the amount before the start date I have choosen in the date slicer.

    I'm using the below DAX to get the selected start date, 

    FromDate = CALCULATE ( MIN ( 'Document Date'[Date] ), ALLSELECTED ( 'Document Date'[Date] ) )

     Then, I'm using the below DAX to get the Amount before the start date. This is not working.

     PreviousDaySum = SUMX( FILTER( ALL(Finance),RELATED('Document Date'[Date])<[FromDate]),Finance[Local_Amount])

     When I hardcode the [FromDate] as below, it works

     HardCodedDetails = SUMX( FILTER( ALL(Finance),RELATED('Date'[Date] )<DATE(2020,02,01)),Finance[Amount])

is there any way to do that dynamically as per my selection in the slicer? You can download the sample file from here: https://1drv.ms/u/s!Am7aqNpyGxlugusCGZxJNEeEnebWgw?e=Qrhhv0

Regards,

Joe

[CNENFRNL · Accepted solution]

Hi, @Anonymous , as to your measure

PreviousDaySum =
SUMX (
    FILTER ( ALL ( Finance ), RELATED ( 'Document Date'[Date] ) < [FromDate] ),
    Finance[Local_Amount]
)

when the measure [FromDate] is referenced in another measure, the evaluation context already dramatically changed, i.e. row context from ALL( finance ) is transited to filter context to evaluate [FromDate].

A correction is straightforward enough,

PreviousDaySum =
VAR __before = [FromDate]
RETURN
    SUMX (
        FILTER ( ALL ( Finance ), RELATED ( 'Document Date'[Date] ) < __before ),
        Finance[Local_Amount]
    )

Yet I myselft prefer to choose "Before" type of slicer on the date column; it does the trick with a simplest measure

Total = SUM( Finance[Amount] )