topic Re: DAX Running Total Problem in DAX Commands and Tips

DAX Running Total Problem

Matt_dev — Fri, 16 Jan 2026 10:43:27 GMT

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

Re: DAX Running Total Problem

Kedar_Pande — Fri, 16 Jan 2026 13:20:59 GMT

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

Re: DAX Running Total Problem

lbendlin — Fri, 16 Jan 2026 13:28:03 GMT

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.

Re: DAX Running Total Problem

Matt_dev — Fri, 16 Jan 2026 13:28:12 GMT

Thank you very much, that is exactly what I needed