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' ...
COUNT
Integer
  • smpa01's avatar
    smpa01
    5 years ago
    Measure :=
CALCULATE (
    COUNTROWS ( Calcul ),
    FILTER ( VALUES ( Calcul[delai] ), Calcul[delai] = 0 )
)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago
Measure :=
CALCULATE (
    COUNTROWS ( Calcul ),
    FILTER ( VALUES ( Calcul[delai] ), Calcul[delai] = 0 )
)