Forum Discussion

ali70's avatar
ali70
Frequent Visitor
5 years ago
Solved

COUNT

Hello guys ,

 

I have a column in which data is between -600 and 2000 , all i want to do is count how many 0 were recorded in this field, any ideas ?

Hint Table name 'Calcul'

column name 'delai'

 

many thanks

COUNT
Integer
  • smpa01's avatar
    smpa01
    5 years ago
    Measure :=
CALCULATE (
    COUNTROWS ( Calcul ),
    FILTER ( VALUES ( Calcul[delai] ), Calcul[delai] = 0 )
)

1 Reply

  • smpa01's avatar
    smpa01
    Community Champion
    5 years ago
    Measure :=
CALCULATE (
    COUNTROWS ( Calcul ),
    FILTER ( VALUES ( Calcul[delai] ), Calcul[delai] = 0 )
)