How do I remove duplicates in a column BUT retain the null and blank cells ?

[Anonymous]

I have a 3 columns of serial numbers, IMEI numbers and phone numbers. I want to remove the duplicates from each column BUT keep the BLANK and NULL cells. Is there a measure to remove the duplicates in all 3 columns BUT keep the NULL and BLANK rows and how do I implement this measure ? The table is named "serial" and the columns are named "IMEI", "Serial Number" and "Phone Number".

[Anonymous]

@Anonymous 

This is not clear since you want to remove duplicates in measures, it is not possible to have them in the same visual without duplicates. If you able to show us an exact output table you are expecting, it would be clear. 

Paul Zheng _ Community Support Team

[ryan_mayu]

@Anonymous 

could you pls provide the sample data and expected output?

[Anonymous]

I have 3 columns in a table called "serial" with "Serial Number" IMEI" and "Phone Number".  There are some empty cells and the word "null" in some.  I need to remove duplicates AND retain the blank cells and null cells.

[ryan_mayu]

@Anonymous 

can we do that in PQ?

select all three columns and remove duplicates.

[banks334]

this usually works for me. It will only remove duplicates if all columns selected are exactly the same. So, if trying to remove duplicate ESN's or some unique number... it will still keep records with different name or whatever other colun you slect before clicking "remove duplicates"

[ryan_mayu]

could you pls provide the sample data (not the screenshot) and the expected output?

[S_JB]

I have seen the following thread which has some potential solutions:

https://stackoverflow.com/questions/53314845/power-bi-remove-duplicates-but-keep-null-values 

Hopefully this helps.

[Anonymous]

Thanks.  Did not resolve.