Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

 

 

Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    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

3 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        TomMartens
        Icon for Super User rankSuper User
        7 years ago

        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