The CountDistinctIf function returns the number of unique values within a column or group for which all given conditions are true.


Syntax

CountDistinctIf([field], condition 1, condition 2+...)

Function arguments:

  • field (required) The column of values to be counted. Duplicate and Null or empty values are skipped.
  • condition 1 (required) The condition to test. If the condition is true, then the row will be counted.

    You can use operators in conditions.

  • condition 2+ (optional) Additional conditions to test. If multiple conditions are used, they must all be True for the row to be counted.

Examples

CountDistinct([City], [Population] > 5000)
  • Finds the number of unique city names where the population is greater than 5000.
CountDistinct([City], [Population] > 5000 AND [Population] < 10000, [State] = "Ohio")
  • Finds the number of unique city names where the population is between 5000 and 10,000 and the state is Ohio.

Related Functions


Was this page helpful?
Yes No