Return value of column B on max of column A

[rpinxt]

I have this simple table that is used in a slicer:

Now I want to have the max that has been chosen in the slicer.

This means if LBE1 and LBE3 are selected I want the measure to return LBE3

With a MAX I can determine the correct Measure Name. Had not expected it to work on names but it seems to be doing it just fine.

Maybe because the ID number in the table.

BUT not only the 'Measure Name' LBE3. There is also a measure called LBE3.

So that is the value I need to return because I want it to calculate LBE3 -/- Actual (or whatever LBE selected is highest)

How would I link the max slicer selection with the corresponding Measure?

[rpinxt · Accepted solution]

Ok was able to fix it myself with a Switch 😁

So if people have a similar problem (realised my subject is not really covering it....)
I already had my max LBE:

MaxLBE = MAX('Measure Selection'[Measure Name])

Then I made the switch:

LBE_Choice =

SWITCH(

    TRUE(),

    [MaxLBE] = "LBE1", [LBE1],

    [MaxLBE] = "LBE2", [LBE2],

    [MaxLBE] = "LBE3", [LBE3],

    [MaxLBE] = "LBE4", [LBE4],

    "Choose an LBE"

)

Note: I also could have made the MAX on the ID from the table and use the numbers in the Switch.