DISTINCT (column) Function (DAX)

How does the DISTINCT (column) function (DAX) work?

The DISTINCT (column) function (DAX) returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed and only unique values are returned.

DISTINCT (column) Formula Syntax

DISTINCT(
     <column>
)

How do you use the DISTINCT (column) function?

The DISTINCT (Column) Function is mainly used for DAX deduplication based on a column. This means that the duplicate values from a column are eliminated and only unique values are kept.

Related Blog Posts

Related Support Forum Posts

How can you create columns of distinct values in Power BI
Two sets of Relations against single reference table
Creating a single unique list, from a similar column is 2 separate tables

Considerations when using the DISTINCT (column) function

The results of DISTINCT are affected by the current filter context. If you use the formula to create a measure, the results would change whenever the table was filtered to show only a particular region or a time period.

Related Video Tutorials

Formula examples using the DISTINCT (column) function

=COUNTROWS(DISTINCT(InternetSales_USD[CustomerKey]))

=COUNTROWS(DISTINCT(Dim[Dim]))

= COUNTROWS (DISTINCT (Sales[Salesperson ID]))

Related DAX Functions

FILTER Function (DAX)
RELATED

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.