APPROXIMATEDISTINCTCOUNT DAX Function (Aggregation)
Counts the approximate number of distinct values in a column. Currently this function is only available on a DirectQuery table from Azure SQL or Azure SQL Data Warehouse.
Syntax
APPROXIMATEDISTINCTCOUNT ( <ColumnName> )
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column for which the distinct values are counted. |
Return values
Scalar A single integer value.
The approximate number of distinct values in ColumnName.
Remarks
The SQL query generated uses the APPROX_COUNT_DISTINCT in Transact-SQL to obtain the result.
Related functions
Other related functions are:
Last update: May 20, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
MSDN documentation: https://docs.microsoft.com/en-us/dax/approximate-distinctcount-function-dax
Black Friday – Footer
2018-2020 © SQLBI. All rights are reserved. Information coming from MSDN is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies