countif() (aggregation function)

Counts the rows in which predicate evaluates to true.

Syntax

countif (predicate)

Parameters

Returns

Returns a count of rows in which predicate evaluates to true.

Examples

Count storms by state

This example shows the number of storms with damage to crops by state.

StormEvents
| summarize TotalCount=count(),TotalWithDamage=countif(DamageCrops >0) by State

The results table shown includes only the first 10 rows.

Count based on string length

This example shows the number of names with more than four letters.

let T = datatable(name:string, day_of_birth:long)
[
   "John", 9,
   "Paul", 18,
   "George", 25,
   "Ringo", 7
];
T
| summarize countif(strlen(name) > 4)

Output

Related content

• Aggregation function types at a glance
• count_distinctif() (aggregation function) - (preview)
• dcountif() (aggregation function)
• count()