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.