cancel
Showing results for
Did you mean:
Creator

## 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)
• ### Set Analysis

1 Solution

Accepted Solutions
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))`

2 Replies
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))`

Creator
Author

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

Tags