Forum Discussion
COUNTROWS without date slicer
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é...
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
TomMartens
Super User
Super UserHey,
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 ?
- TomMartens
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