calculate with the 2 best values

[GeorgW]

Hi, I am calculating the contribution margin in the "Service" table using the following measure:
DB per FTE =
DIVIDE([Revenues minus salary costs], SUM('PersonnelDataCombined'[FTE yearly]))

I now want to get an average of the two best values (per year) as a target. I have already tried with the Rankx formula:
Rank = rankx(all('locations'[district]),[DB per FTE])

and thus get the rank as well.

But how can i now display the sum of the two best values in each case divided by 2 as a measure or value?

[GeorgW]

Thank you!

[Jihwan_Kim · Accepted solution]

Hi, @GeorgW 

Please try the below.

average of top2 =
AVERAGEX (
TOPN ( 2, ALL ( 'locations'[district] ), [DB per FTE], DESC ),
[DB per FTE]
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.