How to find corresponding data that belongs to the outcome of a max function

[DLU]

Dear community, 

I have a table with item transactions. This table also contains a column with specifications on what the item was used in. I've added a measure that shows the last outgoing transaction: 

Last date OUT = MAX('INVENTTRANS OUT MERGED'[INVENTTRANS.DATEPHYSICAL])

Now I want to add the specification that belongs to that date. I've just simply added that column into my visual. It showed the first, and I've changed it to last, but it seems the outcome is based on alphabetical order in stead of related to the max date. I already tried to solve it by used related but that doesn't seem to work. Here is what my current visual looks like. Does anyone have an idea on how to show the specification based upon that last date OUT?

I appreciate the help!

Gr. Diana

[amitchandak]

@DLU , You can use TOPN , TOP 1 or Window for TOP N or Index for topper

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ

Top/Bottom Performer by name and value: https://youtu.be/7O6gHx6Qizw