Forum Discussion
Solved
Adding a filter after removing filter context on the same column
Hi, I am using Azure maps to show 3d columns on given latitudes and longitudes. I have a table that contains latitude, longitude, date,hour and value. I am showing value as a 3d column. I am usin...
Hi, rai024
will it be SUM('MIN_1069 (2)'[Value]) or SUM('MIN_1069'[Value])?
Also use this revised DAX see if it helps.
SelectedValue =
VAR MaxDate = CALCULATE(MAX(MIN_1069[Value.Date]), ALL(MIN_1069))
RETURN
CALCULATE(
SUM(MIN_1069[Value]),
ALL(MIN_1069[Value.Date]), -- remove any filter on the date column
MIN_1069[Value.Date] >= MaxDate - 6,
MIN_1069[Value.Date] <= MaxDate
)
Worked almost. I wanted the largest selected date so I removed the All from the variable and it worked. Thank you. I have been at this for a couple of days.
rai024 if my answer helped you then accept my answer as a solution. So that the thread is marked as completed.
Thanks.