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):
...we can eliminate the duplicate rows with the following DAX expression:
Distinct cities = DISTINCT(Cities)
Related functions
Scenarios
Category
Filter