How to filter out or "null" repeated occurrences of a product each customer

[MarianneElver]

Any suggestions on how to achieve either 1) or 2)?

[Vvelarde · Accepted solution]

@MarianneElver

Hi, in Query Editor, select the 2 columns and go to Remove Rows - Remove Duplicates.

Regards

Victor

Lima - Peru

[Bordalos]

@MarianneElver not sure if I undertand clearly what you want. How the null get to the second table? Are  you looking just for a unique entry for each combination customer/Product ? if is that the case follow  @Vvelarde suggestion. If not ,please provide more details.

[Zubair_Muhammad · Accepted solution]

Hi @MarianneElver

With DAX, you can use the "ALL" function to get unique combination of Rows.

From the Modelling Tab, select NEW TABLE and use this formula

NewTable= ALL(TableName[Customer] , TableName[Product])

[MarianneElver]

Thanks, that's good to know too - as I'm actually need this in a separate table.

[Vvelarde · Accepted solution]

@MarianneElver

Hi, in Query Editor, select the 2 columns and go to Remove Rows - Remove Duplicates.

Regards

Victor

Lima - Peru

[MarianneElver]

Hi, oh so simple, I was convinced that this method would remove duplicates in each column, and not considering the unique combinations. It works, thank you!