Two fact tables

Hi everybody!!
 
I have one Dimension call Indicator
Also, I have two fact tables with the following data
 
IdIndicator    Value
1                   40
 
IdIndicator    Botton Limit       Top Limit         Final Value
1                   0                      10                 1
1                   10                     50                2
1                   50                     100               3
 
I need to calculate a measure that return the value 2 because Value(40) is between 10 and 50
 
Can anyone help me??
 
Thanks in advance
 
Marc

Why do you think the second table is a fact table?

To me it looks like a dimension ... its defining a banding value.

Alternately, it can just be used by the ETL process to populate a "Final Value" column on the primary fact.