calculate max value and put name of that value in the title

[Ethel]

Hello,

I have graph that represents age distribution. For 2022 max age is 'grey age' (20-30),21.2%.

I need to put this information in the title. I have a set analysis formula, that calculates 21.2% correctly. But how can I put  (20-30)in the title?

Just in case my set analysis formula for the age is 

=num(
max(
aggr({<Parametr={'Y'}>}
avg({<Parametr={'Y'}>}
aggr({<Parametr={'Y'}>}
sum({<HParametr={'Y'}>}[HeadCount]),[Period], Age)), Age)
)
/
avg(aggr({< Parametr={'Y'}>}
sum( {< Parametr={'Y'}>}[HeadCount]),[Period]))
,'#,##0.0%')

Thanks a lot in advance!

[Or · Accepted solution]

Generally speaking, the function you'd use to do this is FirstSortedValue(Age,FormulaForSorting).

[Ethel]

should I put this?

FirstSortedValue(Age,

num(
max(
aggr({<Parametr={'Y'}>}
avg({<Parametr={'Y'}>}
aggr({<Parametr={'Y'}>}
sum({<HParametr={'Y'}>}[HeadCount]),[Period], Age)), Age)
)
/
avg(aggr({< Parametr={'Y'}>}
sum( {< Parametr={'Y'}>}[HeadCount]),[Period]))
,'#,##0.0%')).

[Ethel · Accepted solution]

I'm getting "error nested aggregation not allowed". I tried to create master measure, but it this function doesn't see it)

[Or]

I wasn't really able to follow along with that formula as it pertains to your requirement, unfortunately, so I'm not sure if you'd need to apply it as-is or modify it (and if so, in what way).

[Ethel]

set analysis formula works correctly. 

But when I'm trying to apply FirstSortedValue, it doesn't work with set analysis. Is there any other way I can achieve my goal?

Thank you very much in advance!

[Ethel]

Thank you, it worked! I added aggr.

Thank you so much!