Forum Discussion

jmiller21's avatar
jmiller21
Frequent Visitor
5 years ago

Measure Needed for Best Available Option From Ranked List

I need to create a measure that returns the best available option from a ranked list, realtive to two specific fields:  Position and Round.  I have a table that contains the following columns: Roun...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi jmiller21 ,

 

I did a test based on the data you provided. The reason why position A is not ranked until the third round is because there is only one ranking result for position A3 in the original data source, so the values corresponding to other positions in the matrix are empty.

 


If there is still confusion, can you further describe your exact needs so that I can do further testing. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.