Max Value based on if statement

[MIKIEMILLER]

Hello,

I have information like the sample below and I am trying to make a table that looks like the second image.

The problem I am running into is the Savings is summing all the savings for every ID2, and if there are two results, it is only showing one, and the other is a null value.  And if I bring in Results as a dimension, it gives me incorrect totals.

I have ID and ID2 as dimensions.

My expressions(that are working properly) are:

Max Year:        Max({<[CAppeal?]={'Y'}>}[Year])

Years Since last Appeal:        Year(Today(2))-Max({<[Appeal?]={'Y'}>}[Year])

[Channa]

try to check data type 

can you make simple not clear

[Gysbert_Wassenaar · Accepted solution]

Result: FirstSortedValue({<[CAppeal?]={'Y'}>} Result, -[Year])

Savings: FirstSortedValue({<[CAppeal?]={'Y'}>} Savings, -[Year])

[MIKIEMILLER]

I tried using FirstSortedValue as some point, but was using the wrong fields.  Thank you for your help.