countif() (aggregation function)

Counts the rows in which predicate evaluates to true.

Syntax

countif (predicate)

Name	Type	Required	Description
predicate	string	✓	The expression used for aggregation calculation. The value can be any scalar expression with a return type of bool.

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

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.