Forum Discussion
Measure Needed for Best Available Option From Ranked List
Community SupportHi 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.
Henry - appreciate the feedback. Yes, what you described is the result I am getting as well, and the reason makes sense. However, the desired result is that the table would show the best available position rank still available at each round.
So in rounds 1 & 2, A-1 is certainly available, even though it is not shown as selected/ranked until round 3. Was hoping there was a measure that would return this result - and that it would be dynamic based on the selection # (as a slicer). For example, if someone had selection # 4, based on the sample data, the best available would be:
A-1
B-4
C-1
D-1
Maybe it is not a measure that will do this, and I have to create some calculated columns instead?
- v-henryk-mstf
Hi jmiller21 ,
This is not a question of calculated columns or measures. You can use the if condition to judge, when the value in the matrix is empty, fill in the blank value with the ranking result below.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This sounds reasonable. Can you please provide an example of how this measure would look using an if condition to provide the desired result?