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.