DAX Function Guide

DISTINCTCOUNTNOBLANK
Empty image or helper icon

Sam McKay

CEO & Founder

How does the DISTINCTCOUNTNOBLANK work?
The DISTINCTCOUNTNOBLANK function (DAX) counts the number of distinct values in a column.
DISTINCTCOUNTNOBLANK Formula Syntax

DISTINCTCOUNTNOBLANK (
     <column>
)

How do you use the DISTINCTCOUNTNOBLANK?

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

Loading

Considerations when using the DISTINCTCOUNTNOBLANK?

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

Loading

Formula examples using the DISTINCTCOUNTNOBLANK

=DISTINCTCOUNT(ResellerSales_USD[SalesOrderNumber]) “`dax DAX query “`DAX EVALUATE ROW( “DistinctCountNoBlank”, DISTINCTCOUNTNOBLANK(DimProduct[EndDate]), “DistinctCount”, DISTINCTCOUNT(DimProduct[EndDate])

=DISTINCTCOUNT(ResellerSales_USD[SalesOrderNumber]) “`dax DAX query “`DAX EVALUATE ROW( “DistinctCountNoBlank”, DISTINCTCOUNTNOBLANK(DimProduct[EndDate]), “DistinctCount”, DISTINCTCOUNT(DimProduct[EndDate])

DISTINCTCOUNTNOBLANK(‘PRODUCT'[QUANTITY])

Related Courses

Loading