Forum Discussion
Identify Which Measure provides Max Value
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.
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.
Thank you Matt. It took me a bit to figure out your logic, but I do think I got it to work.
Best Regards,