APPROXIMATEDISTINCTCOUNT

APPROXIMATEDISTINCTCOUNT is a DAX function that returns an estimated count of unique values in a column, optimized for performance with slightly reduced accuracy.

Syntax

APPROXIMATEDISTINCTCOUNT( ColumnName )

Argument	Properties	Description
ColumnName		The column for which the distinct values are counted.

Return Values

The approximate number of distinct values in column.

Remarks

The only argument to this function is a column. You can use columns containing any type of data. When the function finds no rows to count, it returns a BLANK, otherwise it returns the count of distinct values.

Empty

Related functions

Other functions related to APPROXIMATEDISTINCTCOUNT are:

• DISTINCTCOUNT
• DISTINCTCOUNTNOBLANK

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/approximatedistinctcount-function-dax