firstsortedvalue return nothing

[#1]

Good afternoon guys, are there something wrong with my syntax? Thanks!

[Chanty4u · Accepted solution]

try below

=FirstSortedValue(Key,-[FoB Price],1)

[MK_QSL]

Try

=FirstSortedValue(Distinct Key,-[FoB Price],1)

or

=FirstSortedValue(Distinct Key,[FoB Price])

[MK_QSL]

Or

Concat(Distinct If([FoB Price] = Min(Total [FoB Price]), Key),', ')

or

Concat(Distinct If([FoB Price] = Max(Total [FoB Price]), Key),', ')

[MK_QSL]

If you have two highest [FoB Price] value, the below expression will return null

=FirstSortedValue(Key,-[FoB Price],1)