DISTINCTCOUNTNOBLANK DAX Function in Power BI
The DISTINCTCOUNTNOBLANK DAX 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: Let’s we have a table with name Sheet1.
Let’s create a measure “Distinct values with Non blank count”.
DAX
Distinct values with Non blank count = DISTINCTCOUNTNOBLANK(Sheet1[MyBranch])
Here, we got the result 6 (excluding the blank value). We can see there are seven distinct values in the column.
