DISTINCTCOUNTNOBLANK

Aggregation

Counts the number of distinct values in a column

DISTINCTCOUNTNOBLANK(<columnName>)