Firstsortedvalue with max and set analysis

[danters182]

Hi,

I am currently struggling with showing the date assigned to my cycling stats:

I used max(MaxSpeed) and firstsortedvalue(datum,-MaxSpeed) for showing the date of my top speed in the textbox, which works fine.

For the average speed, I want to add a set analysis that I only take tours longer than 50km (as the set analysis works in the table) 

It also works with 
=max({$<Distanz={">=50"}>}[Durchschn.Geschw.])&' Km/h
for the key figure, but how can I show the assigned date?

Thanks for your help!

[sunny_talwar · Accepted solution]

This

firstsortedvalue({$<Distanz={">=50"}>} datum,-MaxSpeed)

[danters182]

Works perfectly.

Thanks!