DISTINCT (DAX – Power Pivot, Power BI)

This article is about the DISTINCT function in DAX, which creates new table with unique values (you can also say it removes duplicates…).

Let´s start with this table:

if you want tu make a list of unique values in first column (and create a new table – since standalone DISTINCT only makes sense for table creation), just type:

• Table with unique columns = Distinct(‘Table'[Column1])

The result is like this:

If you want the number of unique values (not the list of them), you can use the DISTINCTCOUNT function.