DISTINCT (table)

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

Syntax

DISTINCT(<table>)  

Parameters

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.

Example

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)