I have my data linked to a Date table that I have created. Since I can easily show numbers depending of a Slicer which is nice.
I was able to do a new measure like so :
Association Total - Début = CALCULATE(
Association_Application[state] = "AttentePublication" || Association_Application[state] = "GrosseAssociation" || Association_Application[state] = "Publiee"
But now I want the exactly same measure but without the slicer in the game.
I tried with ALL() function but I achieve what I want.
Go to Solution.
create a measure that ignores all the filter coming from your date table like so:
Association Total - Début ignoring the date =
[Association Total - Début]
,ALL('name of your calendar table'[name of the column that is used in the relationship]
Hopefully this is what you are looking for.Regards,
View solution in original post
It's working, and thanks for that, but I want to be sure to understand. The slicer put my dashboard in a "time context", but adding ALL() doesn't care of this and overwrite, here, the date range.
That's right ?
basically you are right.
allows to modify exisiting filter before the expression is evaluated.
ALL(...) is a filter modifying function that removes an existing filter on a table or column.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!