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"))
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"))