topic Remove Duplicates by keeping highest value in another column in DAX Commands and Tips

Remove Duplicates by keeping highest value in another column

Anonymous — Wed, 03 May 2023 13:28:18 GMT

Hello,

I want to remove duplicates of 'Part#/Site' (Merged column) from a table 'packaging dump sheet'; keeping the highest 'revision' number for each 'Part#/site'.

I recreated a measure form another post but it did not work- returns only 0s no 1s (See below)

Any help much appreciated.

Adam P

Re: Remove Duplicates by keeping highest value in another column

Wilson_ — Wed, 03 May 2023 22:27:27 GMT

Hello Adam,

Try the DAX you screenshotted as a calculated column, not as a measure. If that doesn't work, try the below instead (as a calculated column):

Column = VAR PartSite = 'Packaging Dump Sheet'[Part#/Site] VAR Revision = 'Packaging Dump Sheet'[ Revision ] VAR FilteredTable = FILTER ( 'Packaging Dump Sheet', 'Packaging Dump Sheet'[Part#/Site] = PartSite ) VAR MaxRevision = MAXX ( FilteredTable, 'Packaging Dump Sheet'[ Revision ] ) VAR Result = IF ( Revision = MaxRevision, 1, 0 ) RETURN Result

P.S.: For future reference, if you share your measure as a screenshot instead of text, you add friction to the process of helping you; somebody would have to re-type out your entire measure to re-create it instead of just copy pasting. Help us help you. 🙂

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Re: Remove Duplicates by keeping highest value in another column

Anonymous — Thu, 04 May 2023 08:24:40 GMT

Hi Wilson,

Thnak you that has solved the issue.

I will make sure to copy/paste my syntax rather than provide a screenshot next time.

Kind regards, Adam P 🙂

Re: Remove Duplicates by keeping highest value in another column

Wilson_ — Thu, 04 May 2023 12:31:33 GMT

Excellent, happy to help Adam. 😄