DISTINCTCOUNTNOBLANK DAX Function
The DISTINCTCOUNTNOBLANK function counts the number of distinct values in a column. Unlike DISTINCTCOUNT function, DISTINCTCOUNTNOBLANK does not count the BLANK value.
DAX Syntax DISTINCTCOUNTNOBLANK([column])
The parameter date is a column containing dates.
Example: Create a calculated column.
DAX
Distinct values count = DISTINCTCOUNTNOBLANK([MyBranch])
Here, we got the result 6 (excluding the blank value).
We can see there are seven distinct values in the column.
