Power BI Reference Table Return Value

[shouck11165]

Hello,

I have a measure (Cost Relativity) that changes as end users change slicers. The example Cost Relativity Value is: .95097350

I need to use this measure value as a lookup to another table where the measure is between the APO_COST_RELATIVITY_LOW and APO_COST_RELATIVITY_HIGH columns and then returns three columns (TARGET_TREND_INFLATOR, SHARED_SAVINGS_CORRIDOR AND SHARED_DEFICIT_CORRIDER) into their own measures for use in calculations later. 

This is the row that should that should be returned from the lookkup sample above:

Any tips would be great. I've read you can used measures for lookups so I'm about out of ideas.

Thanks

Steve

[shouck11165 · Accepted solution]

I ended up putting all scenarios into measures and included them in "if" statements for the calculation measures.

[Ashish_Mathur]

Hi,

While a measure can be used in a calculated column formula, it will be static i.e. it will recalculate only when the Refresh button is pressed.  So effectively, a measure should not be written in a calculated column formula.

[shouck11165]

I meant to say "Can't" use measures in lookups.