Populate value based on MAX value from another column

[Anonymous]

Hi everyone,

I'd like to populate, for each product row, the value in the Units column that's aligned to the maximum percentage for each product. The results I'd like to see are in the Max Units column shaded blue.

Kudos to anyone who can help!

[Anonymous]

@wdx223_Daniel  Perfect, thank you.

[wdx223_Daniel · Accepted solution]

DAX

Max Units=MAXX(TOPN(1,FILTER(Table,Table[Product]=EARLIER(Table[Product])),Table[Percentage]),Table[Units])

M

NewStep=Table.Combine(Table.Group(PreviousStepName,"Product",{"n",each let a=Table.Max(_,"Percentage")[Units] in Table.AddColumn(_,"Max Units",each a)})[n])