Forum Discussion
Remove duplicates but keep blank values
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
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.⚡
3 Replies
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.⚡
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.⚡
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
