DISTINCT (table)

The DISTINCT function that receives the name of a table as an input argument returns the table after eliminating duplicate rows.

Syntax

DISTINCT(
    table
)

Parameters
  • table: Reference to an existing table or expression that returns a table whose unique rows will be returned.
Returned value

The DISTINCT function returns a table.

Examples

If we start from the following table (Cities):

DISTINCT function. Example of use

...we can eliminate the duplicate rows with the following DAX expression:

Distinct cities = DISTINCT(Cities)

DISTINCT function. Example of use
Related functions
Category
Filter
Submitted by admin on Tue, 01/15/2019 - 18:55