Get a value from another value in same table

Hi,

I'm trying to get the "max status" of a ticket based on a column called "paso"

I'm expecting to have the max status value as the following:

In this case max_paso is 4 so I will need to status corresponding to that paso

Is this something that we can achieve in powerbi?

I already tried with a lookupvalue but I'm getting an error