COUNTROWS without date slicer

[Anonymous]

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.

[TomMartens · Accepted 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

[Anonymous]

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