Forum Discussion

Lobs01's avatar
Lobs01
New Member
2 years ago
Solved

Looking up a range

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 GoalTier
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%
Need Help
  • AMeyersen's avatar
    AMeyersen
    2 years ago

    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 )

2 Replies

  • AMeyersen's avatar
    AMeyersen
    Resolver III
    2 years ago

    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 )