Unique Count
Unique Count gives the number of unique (distinct) values in a column. Empty values are not counted.
n 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]).