Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lobs01
New Member

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%
1 ACCEPTED SOLUTION
AMeyersen
Resolver I
Resolver I

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 )

View solution in original post

2 REPLIES 2
AMeyersen
Resolver I
Resolver I

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 )

thank you

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.