Unique Count


The Unique Count measure gives the number of unique (distinct) values in a column. Empty values are not counted. In the table below, column A has a unique count of two and column B has a unique count of three.

Column A

Column B

1

4

 

4

1

3

9

6

Tip: In expressions, the DISTINCT keyword can be used to return a result using the unique values only. For example, Avg(DISTINCT[Column]) would return the average of the unique values rather than the average of all values in the specified column. UniqueCount([Column]) is the equivalent of Count(DISTINCT[Column]).

See also:

Count

Aggregations Overview