How to get the Second Highest Value in Multiple Measures

[ian11001]

Hello Good Day,

I would like to ask a help regarding on my measures, I have 5 numeric measures, and I  need the 2nd highest value of it that I will show in a card visualization. And I'm not sure how to execute it, thank you in advance as always! 

Here are the sample data

[Measure1] = 14

[Measure2] = 10

[Measure3] = 9

[Measure4] = 17

[Measure5] =  20

How do I get the second highest value of it, thank you!

[Idrissshatila]

Hello @ian11001 ,

you could use the following measure

Measure = MAX('Table'[Column1])-1

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[ian11001]

Hello @Idrissshatila , thanks for the reply, the values are in different measure, not in the same columns, how can I compare them?