topic Re: Creation of a table with unique values in DAX Commands and Tips

Creation of a table with unique values

Gwen — Wed, 18 May 2022 07:48:55 GMT

tamerj1 — Wed, 18 May 2022 07:55:14 GMT

Hi Gwen
You can create new table

NewTable = DISTINCT ( SELECTCOLUMNS ( People, "ID", People[ID], "Name", People[Name], "Rank", People[Rank] ) )

Gwen — Wed, 18 May 2022 08:06:02 GMT

So effective... thank you !

Gwen — Thu, 19 May 2022 07:18:46 GMT

Can I add a filter? For example I would like to filter the "empty" IDs. Thank you

tamerj1 — Thu, 19 May 2022 07:32:21 GMT

Gwen yes you can

NewTable = FILTER ( DISTINCT ( SELECTCOLUMNS ( People, "ID", People[ID], "Name", People[Name], "Rank", People[Rank] ) ), [ID] <> BLANK () )

Gwen — Thu, 19 May 2022 07:39:50 GMT

cool thank you. have a good day