Skip to main content
Returns the number of unique values in the specified column Category: aggregate Syntax: 
CountDistinct([column])
Returns: Integer Context Filtering: ✗ No

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to count distinct values

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

CountDistinct([CustomerID])
Returns the number of unique customers
Last modified on March 13, 2026