Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NormanStanleyBadger

Set Analysis with Measures

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]

)

Labels (1)
1 Solution

Accepted Solutions
LRuCelver
Partner - Creator
Partner - Creator

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))

 

View solution in original post

2 Replies
LRuCelver
Partner - Creator
Partner - Creator

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
Author

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