Set Analysis with Measures

[NormanStanleyBadger]

Hi, I hope everyone is well.

I have a table of products and a measure that returns the Max() % value for price / expected price. 

This works fine, however, I would also like to return the price and expected price that are linked to the Max() % value? 

Is it possible to use the result of this first measure in set analysis? 

I written an Aggr() for it below.

Aggr(

{$
<
MySetAnalysis
>
}

Max(
[Result Price / Expected Price] 
)
,
[Dim 1],[Dim 2],[Dim 3],[Dim 4]

)

[LRuCelver · Accepted solution]

If you just need the values for the Price and expected Price you could use the FirstSortedValue function:

=FirstSortedValue(Price, -(Max() % value))
=FirstSortedValue([Expected Price], -(Max() % value))

[NormanStanleyBadger]

You're absolutely right. Doh! Should have spotted that 😀 Thank you.