https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/m-p/974201#M430 <P>This one has been coming up a lot lately in the forums so I figured I would post a solution here. Basically, how do you lookup a value that falls between a range in another table. LOOKUPVALUE cannot be used in this way so you have to MAXX and FILTER your way to victory!</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">LOOKUPVALUE Range = VAR __Score = MAX('Table'[Score]) VAR __ID = MAX('Table'[ScaleID]) VAR __Scale = MAXX( FILTER( 'Scales', 'Scales'[ScaleID] = __ID &amp;&amp; __SCore &gt;= 'Scales'[From] &amp;&amp; __Score &lt;= 'Scales'[To] ), [Scale Result] ) RETURN __Scale</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P class="ics-element-donot-delete 1001_CC@">&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiNGVkODk5OTktYzA4ZS00ODVkLWEwZDQtNGVkN2YxYzNmOWMyIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Sat, 14 Mar 2020 06:07:00 GMT Greg_Deckler 2020-03-14T06:07:00Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/m-p/974201#M430 <P>This one has been coming up a lot lately in the forums so I figured I would post a solution here. Basically, how do you lookup a value that falls between a range in another table. LOOKUPVALUE cannot be used in this way so you have to MAXX and FILTER your way to victory!</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">LOOKUPVALUE Range = VAR __Score = MAX('Table'[Score]) VAR __ID = MAX('Table'[ScaleID]) VAR __Scale = MAXX( FILTER( 'Scales', 'Scales'[ScaleID] = __ID &amp;&amp; __SCore &gt;= 'Scales'[From] &amp;&amp; __Score &lt;= 'Scales'[To] ), [Scale Result] ) RETURN __Scale</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P class="ics-element-donot-delete 1001_CC@">&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiNGVkODk5OTktYzA4ZS00ODVkLWEwZDQtNGVkN2YxYzNmOWMyIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Sat, 14 Mar 2020 06:07:00 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/LOOKUPVALUE-Range/m-p/974201#M430 Greg_Deckler 2020-03-14T06:07:00Z