Forum Discussion
jmiller21
5 years agoFrequent Visitor
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...
v-henryk-mstf
Community Support
5 years agoHi 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.
jmiller21
5 years agoFrequent Visitor
This sounds reasonable. Can you please provide an example of how this measure would look using an if condition to provide the desired result?