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()
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.
Related functions
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



Related content

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