Remove Duplicates but with certain criteria

[colourfullife]

Hi

Need Help.!

Item   Size

a          1

a          2

a          3

b          1

b          1

b          2

Want to remove item duplication but keep with hightest size like below.

currently when i remove duplication in query it remain lower size..

[Desiral Table]

Item   Size

a          3

b          2

[v-shex-msft · Accepted solution]

Hi @colourfullife ,

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] ) )

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @colourfullife 

Just create a Measure

Measure = MAX(Size)

and pull Item and the above measure.

Thanks

Raj