Looking up a range

[Lobs01]

Hi There, 

I am trying to lookup my measure to the table listed below, is there a way i can get this via a measure?

My end goal is for example my Measure is equivalent to 95.9% it should fall under Tier 60%

To Goal	Tier
0.00%	0%
87.00%	10%
89.00%	20%
91.00%	30%
93.00%	40%
94.00%	50%
95.00%	60%
96.00%	70%
97.00%	80%
98.00%	90%
99.00%	93%
100.00%	95%
100.50%	98%
101.00%	100%
101.50%	103%
102.00%	105%
102.50%	108%
103.00%	110%
104.00%	113%
105.00%	115%
106.00%	118%
108.00%	118%
110.00%	120%

[AMeyersen · Accepted solution]

Hi @Lobs01 ,

the secret is to use a variable to store the value of myMeasure. Otherwise you can't use it as filter in a CALCULATE formula:

tierMeasure =
VAR _measureValue = [myMeasure]
RETURN
    CALCULATE ( MAX ( 'Table'[Tier] ), 'Table'[ToGoal] <= _measureValue )

[Lobs01]

thank you