CountDistinct
CountDistinct(column) · Aggregation
Counts distinct non-NULL values (SQL COUNT(DISTINCT col)). Over zero rows it returns 0.
Example
Section titled “Example”Orders := CountDistinct(Sales.OrderId)Good to know
Section titled “Good to know”- Not additive — it cannot be accumulated by
YTD/RollingSum(SQX015): a sum of daily distinct counts double-counts repeat values.