Forum Discussion
Measure Needed for Best Available Option From Ranked List
Solution Sage"A picture WOULD BE worth a thousand words." And some data that we could copy and play with would be handy too... If in doubt, please check this: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523
Cheers.
Apologize - I was not sure if my example was simple enough to work through, but see below. Table on the left is an example of how the data would look (limited, only first 32 rows of 240). I have a related table which has a relationship between "OVER PICK" to the data table's "RANK". From there, I crated a slicer for "SELECTION" which is 1-12. Desired result is to slice on Selection, and have the matrix/table return the best available option by Position for each Round. The example below you will see the data, and how Position A does not get ranked until Round 3. Most of the measures I have created do not do a good job of translating future availability/selections as available in current rounds, especially in the case of Position A which is not ranked until Round 3. Hopefully this helps, but if not, please let me know.
