Set Expression Question

[#1]

Assuming the following data:

Quote	Version	Total
A	1	$500
A	2	$1000
A	3	$700
B	1	$1200
B	2	$800
C	1	$900

I was trying to create a Measure that would only calculate the Total from the MAX version, so in this case $700, $800 and $900 and display them in a table like this:

Quote	Total
A	$700
B	$800
C	$900

But my formula isn't working. I thought the formula would look something like this:

Sum({<Version=Max(Version)>} Total)

or

Sum({<Version={Max[Version]}>} Total)

The top formula doesn't give me a value. The bottom gives me $0 every time. What am I doing wrong? Do Set Expressions work in Tables?

[Anonymous]

try to use

Sum({< Version ={$(=Max(Version))} >} Total)

[sunny_talwar]

May be this

FirstSortedValue(Total, -Version)

[vijetas42 · Accepted solution]

HI,

try to use expression like,aggr(FirstSortedValue(sale,-version),quote)

[#5]

vijeta, your solution worked like a charm! Thank you.

[vijetas42]

If you got your solution then please mark it as correct and close the thread.

Thanks!

[Lucke_Hallbergson]

Aggr function should be wrapped in an aggregation as it returns an array of values;

[sunny_talwar]

You want to unnecessarily use Aggr() function (when it is not even needed here)? Did you even try this expression?

FirstSortedValue(Total, -Version)

I think you should avoid using Aggr() function unless I am missing something here.... Check my response and attached image and application above and see if it gives what you wanted

Re: Set Expression Question