How does the DISTINCTCOUNTNOBLANK function (DAX) work?
The DISTINCTCOUNTNOBLANK function (DAX) counts the number of distinct values in a column.
DISTINCTCOUNTNOBLANK Formula Syntax
How do you use the DISTINCTCOUNTNOBLANK function?
The DISTINCTCOUNTNOBLANK function is useful because they do exactly what their names suggest: Counting the distinct values of a column, which it takes as its only parameter.
Related Blog Posts
Related Support Forum Posts
Considerations when using the DISTINCTCOUNTNOBLANK function
Whenever we enter empty values in the text columns, it behaves as empty values, but when we enter an empty value in numeric or logical columns, it behaves as null values.
The DISTINCTCOUNTNOBLANK function in dax count unique empty values, but It does not count null values.
Related Video Tutorials
Formula examples using the DISTINCTCOUNTNOBLANK function
=DISTINCTCOUNT(ResellerSales_USD[SalesOrderNumber]) “`dax DAX query “`DAX EVALUATE ROW( “DistinctCountNoBlank”, DISTINCTCOUNTNOBLANK(DimProduct[EndDate]), “DistinctCount”, DISTINCTCOUNT(DimProduct[EndDate])
Related DAX Functions
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.