Forum Discussion
Measure Needed for Best Available Option From Ranked List
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?
Community SupportHi 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?