DAX dynamic sum between two dates, when the date slicer is one of the parameters

[aaquis]

Hello,

I've been trying, unsuccessfully, to calculate a measure summing up values between two dates. The lower limit date is MIN(Calendar[Date]) while the upper limit should be a dynamic selection from a Date Slicer. 

The last two items I've tried are: 

MNQ EndBalance = CALCULATE(SUM(Quantities[Value]),DATESBETWEEN('Calendar'[Date],
MIN('Calendar'[Date]),CALCULATE(MIN(Calendar[Date]),ALLSELECTED(Calendar[Date]))))

MNQ EndBalance = CALCULATE(SUM(Quantities[Value]),DATESBETWEEN('Calendar'[Date],
MIN('Calendar'[Date]),SELECTEDVALUE(Calendar[Date]))).

Link to sample file here: BetweenDatesSampleFile 

Any suggestions would be highly appreciated.

Thank you.

[DataInsights · Accepted solution]

@aaquis,

Try this measure:

MNQ EndBalance = 
VAR vStartDate =
    MINX ( ALL ( 'Calendar' ), 'Calendar'[Date] )
VAR vEndDate =
    MAXX ( ALLSELECTED ( 'Calendar' ), 'Calendar'[Date] )
VAR vResult =
    CALCULATE (
        SUM ( Quantities[Value] ),
        DATESBETWEEN ( 'Calendar'[Date], vStartDate, vEndDate )
    )
RETURN
    vResult

[aaquis]

Perfect! Works as expected.

Thank you so much, @DataInsights!