Remove duplicates but keep blank values

[Sudhavi_84]

Hi All,

I have to remove the duplicates in Table A, one of the column but would like to keep the blank or null values as it is..

How can I acheive this? I think we can do using summarise function but no idea how to do it.

I already added 2 calculated columns comparing with other table B and want to keep that 2 calculated columns in Table A.

Can I summarise Table A by removing duplicates, keeping blank values and also 2 calculated columns?

Thank you in Advance

[parry2k · Accepted solution]

@Sudhavi_84 you can create a new calculated table using following DAX:

New Dup = 
UNION (
    DISTINCT ( FILTER ( Dup, NOT ISBLANK ( Dup[ID] ) ) ),
    FILTER ( Dup, ISBLANK ( Dup[ID] ) )
)

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Sudhavi_84 can you post the sample data in table format and explaining the expected output.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Sudhavi_84]

Hi My actual table is below

And desired output what I need is 

reason for removing duplicates and keeping null values in  ID column is because I want to build the visual based on Region level and Calculated column please

Thanks in advance