DISTINCT (table)

Applies to: Calculated column Calculated table Measure Visual calculation

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

Syntax

DISTINCT(<table>)

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.

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