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
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
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 (Sales[Salesperson ID]))
Related DAX Functions
Related Course Modules
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.