Extracting value based on max value from another column from each subgroup

[arveseba]

Hi, 

I want extract value based on max value from another column from each subgroup. I tried ALLEXCEPT(), MAX() and another functions in DAX, but still im not found solution.

The final solution should look like the "Line" column is the value from the "Operation" column, where the maximum value is from the Internal column.

An example solution is in the attachment.

Can anyone suggest how to solve this?

[PattemManohar · Accepted solution]

@arveseba Please use this as "New Column"

Line = LOOKUPVALUE(Test07MaxValWithinGroup[Opeartion],
                   Test07MaxValWithinGroup[Internal],
                   MAXX(FILTER(Test07MaxValWithinGroup,Test07MaxValWithinGroup[Employee]=EARLIER(Test07MaxValWithinGroup[Employee])),Test07MaxValWithinGroup[Internal])
                   )

Note - Please try to post the sample data in copiable format which makes life easier.