CountDistinct

The CountDistinct function returns the number of unique values within a column or group.

Syntax

CountDistinct(column)

Function arguments:

  • column (required) The column of values to be counted. Duplicate and Null or empty values are not counted.

Example

CountDistinct([City])

  • Returns the number of unique city names.

Related resources