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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership