You need to create the sales territory and product measures. Which aggregate function should you use for both measures?

COUNT(DISTINCT column_name) is T-SQL syntax used in relational queries; it is not a valid SSAS measure aggregate function type selectable in the Multidimensional model designer.

Distinct Count is the built-in SSAS aggregate function specifically designed to count the number of unique non-null values in a column. SSAS handles Distinct Count measures with specialized storage and query processing because they cannot be pre-aggregated across dimensions the same way SUM or COUNT can. It is the correct choice when the business requirement is to count unique occurrences - such as unique sales territories or unique products sold.

Distinct is not a recognized aggregate function type in SSAS Multidimensional or Tabular; it does not exist as a selectable aggregation option for measures.

Count counts all rows including duplicates and does not deduplicate values, so it would overcount when the goal is to measure the number of unique territories or products.