Distinct

Purpose:

Affects the higher order aggregate function (e.g. Sum(), Avg(), Count()...) and causes equal values only to be used once in the calculation.

Parameter:

All

Return value:

All

Example:

CountIf(Distinct(Customers.Region="EMEA"))