Count Vs Count All function

Count and Count All functions display how many records are in a report. However, there is a big difference between the two functions:

Count function counts the distinct values in a column that contains a dimension object. It counts each value only once and ignore duplicates.

Count All counts all the rows in a column, including duplicates and empty rows.

Count function counts all rows in a column that contains a measure object. That is, for a measure object Count function behaves the same as Count All.

Count(“Test”) returns 1

Count([City];Distinct) returns 5 if there are 5 different cities in a list of cities, even if there are more than 5 rows in the list due to duplication.

Count([City];All) returns 10 if there are 10 cities in a list of cities, even though some are duplicated.

Count ([City];IncludeEmpty) returns 6 if there are 5 cities and one blank row in a list of cities.

Leave a Reply