Lobs01New Member2 years agoSolvedLooking 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...Show MoreAMeyersen2 years agoHi 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 )
AMeyersen2 years agoHi 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 )
AMeyersen2 years agoHi 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 )
AMeyersenResolver III2 years agoHi 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 )
Related contentLooking for the connector NameLook up using date rangeWhitelist IP rangesCongested X-Axis Rangelooking up values where two ranges apply
