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

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

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