The Count measure gives the number of values in a column, not counting empty values. In the table below, Column A has a Count of 3, while Column B has a Count of 4.
Column A |
Column B |
1 |
4 |
|
7 |
8 |
3 |
9 |
6 |
The CountBig measure is used when the number of counted values is very large. It returns a LongInteger instead of an integer.