A possible solution would be to use a SWITCH statement. Here is some info to review on that.
Just to clarify, is this a table that you have in your model that we need to base the solution off of, or is there another column or measure that brings back the # that meets the criteria in the table shown.
Thanks
