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( COUNTROWS(Associations), FILTER( RELATEDTABLE(Association_Application), 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.
Solved! Go to Solution.
Hey,
create a measure that ignores all the filter coming from your date table like so:
Association Total - Début ignoring the date = CALCULATE( [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,
Tom
Hey,
create a measure that ignores all the filter coming from your date table like so:
Association Total - Début ignoring the date = CALCULATE( [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,
Tom
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 ?
Hey,
basically you are right.
CALCULATE(<expression>,<filter1>,...,<filterN>)
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.
Regards,
Tom