show highest value through set analysis

[cedfoning]

Hello, i have an issue i need help please. 

I have the following data : 

date	ID	Amount	Code	Transaction ID
Total		742,11
15/02/2024	224	259,67	2	2024021508312521
15/02/2024	224	185,35	2	2024021514530321

I want to create a measure (Set analysis) that gives me the amount with the highest transaction id. 

in this exemble, the result should be one lie with the amount 185,35

Thanks

[qv_testing]

Try this 

LOAD *, RecNo() as RecNum;
LOAD * INLINE [
date, ID, Amount, Code
15/02/2024, 224, 25967, 2
15/02/2024, 224, 18535, 2
];

Expression: =FirstSortedValue(Amount, -RecNum)