DISTINCTCOUNT DAX Function

The DISTINCTCOUNT DAX function returns the counts of the number of distinct values in a column. It counts the repeated values only once. It also counts the blank values in the column.

DAX Syntax DISTINCTCOUNT([column])

Example: The following expression counts the distinct values in the column MyBranch.

DAX