Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
I ended up putting all scenarios into measures and included them in "if" statements for the calculation measures.
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.
I meant to say "Can't" use measures in lookups.
User | Count |
---|---|
119 | |
78 | |
58 | |
52 | |
46 |
User | Count |
---|---|
170 | |
117 | |
63 | |
58 | |
51 |