Forum Discussion
Solved
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 tab...
I ended up putting all scenarios into measures and included them in "if" statements for the calculation measures.
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.