Hello all, I currently have a date column that I'm using in a measure; however, I have a page-level filter that makes sure the date is only the most recent one, however, for a measure, I want to make it so it doesn't apply to the column when its being used in that measure, I tried the ALL function but I don't know how to make it so that it returns the same column just not filtered.
Thanks.
Objective: Use the Date column in a measure without it being filtered by the page-level filter, which checks to see what the latest date is and returns true if its the case, and false otherwise. This value is currently set to true on the page, so it only retrieves the latest date I want to return the goals scored per day for a specific visual, so I'm trying to create this specific measure that won't take this filter into account for the date. I.E SUM([Goals_Scored]) would return the sum of goals scored per day, and not just for the most recent date.
Currently: It is only getting the goals scored for the most recent date, I.E only one point on a line graph.
Wanted result: The line graph would have points for all the existing dates, which would tell me how many goals were scored on that date.
Thanks.
