INDEX function and ORDERBY

[Kazu]

I would like to define a measure which use INDEX(). The test measure blow specifies hardcoded "2" in the INDEX() function and it returns "B", which if I understand correctly is the second Name in the alphabethical order of Name. 

Now, how can I get the second name in the order of Sort column instead of Name column? I want "A" instead of "B" because its Sort value is "2" and considered the second". I tried to add ORDERBY like below but it did not allow me to select other columns than Name. I guess I should avoid using VALUES but use ADDCOLUMNS or something, but couldn't figure out how to do it.

[Kazu · Accepted solution]

I am not sure if this would be of help for anybody else, but I found a solution.

[Anonymous]

Hi, @Kazu 

Glad to hear you solved the problem yourself!  

Best Regards

Yongkang Hua

[lbendlin]

Instead of VALUES('Table'[Name]) use VALUES('Table'[Sort])

[Kazu]

Thanks but that would return "2" instead of "A". I found a solution myself.