DISTINCT (table)

Returns a table by removing duplicate rows from another table or expression.




Term Definition
table The table from which unique rows are to be returned. The table can also be an expression that results in a table.

Return value

A table containing only distinct rows.

There is another version of the DISTINCT function, DISTINCT (column), that takes a column name as input parameter.


The following query:

EVALUATE DISTINCT( { (1, "A"), (2, "B"), (1, "A") } )

Returns table:

[Value1] [Value2]
1 A
2 B

See also

Filter functions (DAX)
DISTINCT (column) (DAX)
FILTER function (DAX)
RELATED function (DAX)
VALUES function (DAX)