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]))