Forum Discussion
Identify Which Measure provides Max Value
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,
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.
2 Replies
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,
