Remove Duplicates but with certain criteria

Question

Hi&nbsp;Need Help.!&nbsp;Item&nbsp;&nbsp; Sizea&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;Want to remove item duplication but keep with hightest size like below.currently when i remove duplication in query it remain lower size..&nbsp;[Desiral Table]Item&nbsp;&nbsp; Sizea&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3b &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
I'd like to suggest you write a calculated table with summarize function to remove duplicate records.
New Table =
SUMMARIZE ( Table, [Item], "Max Size", MAX ( Table[Size] ) )

&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Remove Duplicates but with certain criteria

2 Replies

Related content

Duplicate ranking

Return Duplicates when Criteria Matched

remove duplicate value within a row

Duplicate IDs with criteria

Removing Duplicates