Identify Which Measure provides Max Value

[rsbin]

Good Afternoon,

I have the following setup:

Site	Measure1	Measure2	Measure3
A	5500	5600	5400
B	3500	2500	4000

Using the following Measure, I can get the Max Value for each Site.

MaxValue = MAXX(
               {[Measure1],
                [Measure2],
                [Measure3] },
           [Value] )

  However, I also need to capture which Measure( 1, 2, or 3) provides that Max Value. 

Final Result:

A	Measure2	5600
B	Measure3	4000

Thanks and Best Regards,

[MattAllington · Accepted solution]

Seems like your measure is giving the result you need for the number. Maybe you can then evaluate each measure and use a switch statement for the measure name. Something like

which measure = SWITCH(TRUE(),

[Measure1]=[MaxValue],"Measure 1",
[Measure2]=[MaxValue],"Measure 2",

[Measure3]=[MaxValue],"Measure 3")

this assumes only one measure is the max, otherwise you would need to concatenate the above. 

[rsbin]

@MattAllington ,

Thank you Matt.  It took me a bit to figure out your logic, but I do think I got it to work.

Best Regards,