remove duplicates over 2 column dax

[GianlucaM]

Hi 

I need to create a Dim table based on fact, and I need to avoid to use power query.

What i'm trying to get it's a DAX that allows me to select some columns from a table, and gives me back just the unique value. 
Something you can easilly do by selecting the two column and type "remove duplicates" in power query.

Doing it in DAX would let me have a lighter file
Here an example
From

A	B	C
Red	2	big
Red	2	Small
Jellow	1	Big

I need to obtain
AB

A	B
Red	2
Jellow	1

[barritown · Accepted solution]

Hi @GianlucaM,

This line should help you to achieve the required outcome:

New Table = SUMMARIZE ( 'Table', 'Table'[A], 'Table'[B] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian