DISTINCT DAX Function in Power BI
The DISTINCT DAX function returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed, and only unique values are returned.
DAX Syntax DISTINCT(column)
The function takes the column as a parameter from which unique values are to be returned. Or an expression that returns a column.
Example: Let’s we have the following table named Countries.
Let’s create a calculated table using the below dax expression, where we need to find the distinct values from the column of a table.
DAX
DISTINCT Values Table = DISTINCT(Countries[Country])
The output of the above dax function is shown below:
