DISTINCTCOUNTNOBLANK

Aggregation

Counts the number of distinct values in a column.

DISTINCTCOUNTNOBLANK(<column>)