Forum Discussion

Milozebre's avatar
Milozebre
Helper V
9 years ago
Solved

CountRows with filters

Good afternoon, 

 

I have a table that includes records with a number of actions.
To know the number of files, I choose the number distincitfs.
I create a measure and use the Countrows command : COUNTROWS(distinct('Dossiers Traités/Equipe'[NumeroDossier]))
It works, I have the right number.
Now I would like to add filters of this type: Filter('Dossiers Traités/Equipe' [EquTrait] = "Voture"  || 'Dossiers Traités/Equipe'[EquTrait] = "Moto"

But he tells me that there is only one argument. Can you tell me where I am wrong?

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Try:

    Measure = CALCULATE(DISTINCTCOUNT('Dossiers Traités/Equipe'[NumeroDossier]),FILTER('Dossiers Traités/Equipe',

    'Dossiers Traités/Equipe' [EquTrait] = "Voture"  || 'Dossiers Traités/Equipe'[EquTrait] = "Moto"))

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Try:

    Measure = CALCULATE(DISTINCTCOUNT('Dossiers Traités/Equipe'[NumeroDossier]),FILTER('Dossiers Traités/Equipe',

    'Dossiers Traités/Equipe' [EquTrait] = "Voture"  || 'Dossiers Traités/Equipe'[EquTrait] = "Moto"))

    • Milozebre's avatar
      Milozebre
      Helper V
      9 years ago

      Hello, 

       

      In as short a time.
      Unbelievable :)

      I feel a little silly :)
       
      thank you very much.
       
      Have a nice day 
       
  • Ramadevi's avatar
    Ramadevi
    Frequent Visitor
    9 years ago

    Hi,

     

    Try this once. Hope this helps.

     

    MeasureTest = COUNTROWS(DISTINCT(FILTER('Dossiers Traités/Equipe','Dossiers Traités/Equipe' [EquTrait] = "Voture"  || 'Dossiers Traités/Equipe'[EquTrait] = "Moto")))