Forum Discussion
Power BI Reference Table Return Value
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
I ended up putting all scenarios into measures and included them in "if" statements for the calculation measures.
3 Replies
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.
I meant to say "Can't" use measures in lookups.
I ended up putting all scenarios into measures and included them in "if" statements for the calculation measures.
