Forum Discussion
Can a Measure be used in the Lookupvalue function
Hey jonathona321 ,
I'm wondering what you are creating in table 1, a calculated column?
You have to be aware that calculated columns will only be evaluated during data refresh, an (re)evaluation of a calculated column is not triggered by a slicer selection or any other interaction of an user with the data.
Nevertheless, the simple answer is: No!
LOOKUPVALUE has a column reference as a 1st parameter, and for this reason a measure can not be used.
Regards,
Tom
Hey jonathona321 ,
I'm wondering what you are creating in table 1, a calculated column?
You have to be aware that calculated columns will only be evaluated during data refresh, an (re)evaluation of a calculated column is not triggered by a slicer selection or any other interaction of an user with the data.
Nevertheless, the simple answer is: No!
LOOKUPVALUE has a column reference as a 1st parameter, and for this reason a measure can not be used.
Regards,
Tom
Hi TomMartens
Thanks for the simple anwser, i will have to change my approach then.
Without to much detail i am trying to do a sensitivity anaylsis on failure mode liklihoods of equipment. The first table has my likelihoods and the second table is where the final calculation is done. I then wanted to take the likelihood of failure that was calculated and return it to the first table where i could do some simple arithmetic and get the likelihood of failure for when each barrier protecting the equirment has varied effectivness. ( i know i could probably use What if parameters or set up the tables differently but this approch seemed to be best as i will always have a varying data size).
Thanks,
Jonathon