Calculating Cumulative Totals for a Measure DAX

[vicky_]

Hello! 

I've run into a problem trying to make the following measure cumulative. The first screenshot shows my current output, and the part in the red box is what I want as an output. The week date range is a calculated column based on my Date Table. 
The user needs to be able to set the date range in the slicer. 

Weekly Spend Goal = 
var daysInPeriuod = CALCULATE(COUNT('Date'[Date]))
var allDays = COUNTX(ALLSELECTED('DateTable'[Date]), DateTable[Date])
var weeklyAmt = DIVIDE(1000, allDays) * daysInPeriuod
return weeklyAmt

Screenshot 1 showing my current output & desired output

Screenshot 2: the date table 

Thanks in advance for any help.

[Anonymous · Accepted solution]

Try this...

Spend Goal (Tier 1) = 
VAR LastDateInRange = MAXX(ALLSELECTED('Date'),'Date'[Date])
VAR FirstDateInRange = MINX(ALLSELECTED('Date'),'Date'[Date])
VAR AllDays = 
    COUNTROWS(
        FILTER(
            ALLSELECTED('Date'),
            'Date'[Date]>=FirstDateInRange && 
            'Date'[Date] <= LastDateInRange
            )
        )
VAR DIP = 
    COUNTROWS(
        FILTER(
            ALLSELECTED('Date'),
            'Date'[Date]>=FirstDateInRange && 
            'Date'[Date] <= MAXX('Date','Date'[Date])
            )
        )
RETURN DIVIDE(1000,AllDays)*DIP

[vicky_]

Hey thank you!