cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors