To display the highest number and Name

[rkpatelqlikview]

Hi,

Please let me know the set expression for below scenario.

I want to show the top Driver name who has driven highest Green kms travelled.

One text object should show Driver Name another Green Kms travelled. Expression for Green km Travelled - =sum({<DriverClassification={'SGreen'}>}[Kms Travelled]). Given in Straight table.

from Below straight table. I need show the name Rakesh Kumar (highest kms travelled) and in one more text object we need show kms travelled that value 43078.

thanks in advance

[petter · Accepted solution]

This expression in a text box should give you RAKESH KUMAR:

=Only( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Driver Name] )

This expression in another text box should give you 43078:

=Sum(  {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Kms Travelled] )

[rkpatelqlikview]

Thanks for your response Petter,

Expression ok but its not giving the output.

Here my intention is need show all the drvier names like below.. Please suggest another expression.

[rkpatelqlikview]

Thanks Petter, its working now properly.