DAX – DISTINCTCOUNT Function

Power BI DISTINCTCOUNT DAX function is used to counts the number of distinct values in a column.

This functions comes under Aggregation functions Dax categories.

Refer similar DAX : DISTINCTCOUNTNOBLANK

Syntax:

DISTINCTCOUNT(<column>)

Description:

Dataset format as below:

Note:

1. The only argument allowed to this function is a column.
2. DISTINCTCOUNT function includes the BLANK value.
3. When the function finds no rows to count, it returns a BLANK, otherwise it returns the count of distinct values.

Step 1: Now, we will count the distinct number of values in the ‘Amount’ column. To do this, create a new measure.

DISTINCT COUNT = DISTINCTCOUNT(SampleTable[Amount])
--Output= 3

With Blank column:-
DISTINCT COUNT = DISTINCTCOUNT(SampleTable[Blank])-- Output = 1

With ID column:-
DISTINCT COUNT = DISTINCTCOUNT(SampleTable[ID])--- Output = 4

With SalesDate column:
DISTINCT COUNT = DISTINCTCOUNT(SampleTable[SalesDate])---- Output = 3

You can also used DISTINCTCOUNT DAX with FILTER Function:

DistinctCountWithFilter =

CALCULATE(
DISTINCTCOUNT( SampleTable[Amount] )
,Filter(SampleTable, SampleTable[ID] IN {1,2,4} )
)
--Output = 2

Refer similar DAX : COUNTROWS , COUNTBLANK ,  COUNT, COUNTA & COUNTX

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.