Compare value from one table with values from another table.

Anonymous 

this is the pricing table with discount for each occupancy limit 

then there is sales table where i have the measure of current occupancy for each day, season etc.

then i have season table which is this one

pricing table and sales table have both active relationship to seasons table many to one.

so i want to create a measure called suggested special offer which will calculate a suggested discount for each season

based on the current occupancy.

for example for season 1. if current occupancy is 43% then the discount will be bar3 -5%

                                         if current occupancy is 36% then the discount will be bar4 -10%

occupancy is simple measure