Table of contents
TOC
Collapse the table of content
Expand the table of content

DISTINCT (table) Function

Owen Duncan|Last Updated: 5/22/2018

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

Syntax

DISTINCT(<table>)  

Parameters

TermDefinition
tableThe 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]
1A
2B

See Also

Filter Functions (DAX)
DISTINCT (column) (DAX)
FILTER Function (DAX)
RELATED Function (DAX)
VALUES Function (DAX)

© 2018 Microsoft