DAX Running Total Problem

[Matt_dev]

I have seen versions of this question asked and answered here many times but I can't get any of those answers to work for my situation.

I have a dataset called VW3 which contains sales data over dimensions like location, staff member, project and date.

I have created a new dataset which contains only the distinct dates from VW3 called SAD. I have also created a measure on SAD called Selected

Selected = SELECTEDVALUE('SAD'[Date])

SAD and VW3 have a 1 to many relationship between VW3.ShiftDate AND SAD.Date. 

I have a date slicer (which uses the Between style) using the SAD dataset and I want to create a total of sales for that period, ignoring all other dimensions and have tried the following 

GMRunningTotal =

VAR StartDate = MIN(SAD[Date])

VAR EndDate = MAX(SAD[Date])

RETURN

CALCULATE(

    SUM(VW3[PL]),

    FILTER(

        ALL(SAD),

        'SAD'[Selected] >= StartDate && 'SAD'[Selected] <= EndDate

    )

)

I know I am doing something wrong because GMRunningTotal changes if I alter the value of the dimension slicer but I only want date to affect it.

Please, if you are able, tell me where I am going wrong because I have become very confused and do not know how to proceed.

Thanks in advance 

[lbendlin]

I know I am doing something wrong because GMRunningTotal changes if I alter the value of the dimension slicer but I only want date to affect it.

Don't join the tables if you don't want the filter context to impact your results. Use overrides like REMOVEFILTERS, and consider using window functions instead.

[Kedar_Pande · Accepted solution]

@Matt_dev 

Try:

GMRunningTotal = 
CALCULATE(
SUM(VW3[PL]),
DATESBETWEEN(
SAD[Date],
MIN(SAD[Date]),
MAX(SAD[Date])
)
)

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[Matt_dev]

Thank you very much, that is exactly what I needed