DISTINCTCOUNT DAX Function in Power BI
The DISTINCTCOUNT DAX function returns the counts of the number of distinct values in a column. It counts the repeated values only once. Unlike DISTINCTCOUNTNOBLANK function, DISTINCTCOUNT count the BLANK value in the column.
DAX Syntax DISTINCTCOUNT([column])
Here, the parameter column specifies from which column we want to find the distinct values.
Example: Let’s create a measure which given the count of distinct values in the column MyBranch of Sheet1 table.
DAX
Distinct values count = DISTINCTCOUNT([MyBranch])
The output of the above code can be shown in the card visual as shown in the image below:
