Remove Duplicates by keeping highest value in another column

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