Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper 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 : ...
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"))

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
    Icon for Helper V rankHelper V
    9 years ago

    Hello, 

     

    In as short a time.
    Unbelievable :)

    I feel a little silly :)
     
    thank you very much.
     
    Have a nice day