Forum Discussion
DAX Running Total Problem
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
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
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
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
3 Replies
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-pandeThank you very much, that is exactly what I needed
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.
