DISTINCT (table) Function (DAX)

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

The DISTINCT (table) function (DAX) returns a table by removing duplicate rows from another table or expression.

DISTINCT (table) Formula Syntax

DISTINCT(
     <table>
)

How do you use the DISTINCT (table) function?

The DISTINCT (table) is used to removed the duplicate rows from the table.

Related Blog Posts

Related Support Forum Posts

Creating a new table from multiple other tables with similar data
Iterating a distinctcount between two tables
Drilldown and Relationship Issue

Considerations when using the DISTINCT (table) function

If the parameter is a single table, the result of DISTINCT is affected by the current filter context. In this case it is important to understand the differences with VALUES, which might add an additional blank row in certain conditions.
If the parameter is a table expression, DISTINCT returns a table by removing duplicate rows provided by the table expression.

Related Video Tutorials

Formula examples using the DISTINCT (table) function

EVALUATE DISTINCT( { (1, “A”), (2, “B”), (1, “A”) } )

DISTINCT = COUNTROWS(DISTINCT((Items[ItemName])))

=COUNTROWS(DISTINCT(‘ResellerSales_USD'[ProductKey]))

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