cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gilHA Frequent Visitor
Frequent Visitor

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é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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: COUNTROWS without date slicer

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
3 REPLIES 3
Super User
Super User

Re: COUNTROWS without date slicer

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
gilHA Frequent Visitor
Frequent Visitor

Re: COUNTROWS without date slicer

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 ?

Super User
Super User

Re: COUNTROWS without date slicer

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!