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.

1 Comment

  1. Impressive! Thanks for the article.
    King regards,
    Harrell Hessellund

Leave a Reply

Your email address will not be published.

*

clear formPost comment