Forum Discussion
Unable to return Value from measure to Calculated Column
Hi All,
Must be a simple fix for pro users like you..My Measure is as here
'Measure
dYNAMICMEASURE = SWITCH(SELECTEDVALUE('Table'[Value]),
dYNAMICMEASURE = SWITCH(SELECTEDVALUE('Table'[Value]),
15,14,
30,29,
45,44,
60,59,
59)
'Calculated Column
'Calculated Column
testpiece = [dYNAMICMEASURE]
The above testpiece returns 552004 ?
May i know how i can overcome this problem
Thanks a ton
The above testpiece returns 552004 ?
May i know how i can overcome this problem
Thanks a ton
Anonymous - Calculated columns are only calculated at the time of data refresh so using measures in them is generally not a good idea or won't act the way you want.
Anonymous , Column can not take slicer values. So the what value measure will get can not be used.
Just see how can you use measure
2 Replies
- Greg_Deckler
Community Champion
Anonymous - Calculated columns are only calculated at the time of data refresh so using measures in them is generally not a good idea or won't act the way you want.
- amitchandak
Super User
Anonymous , Column can not take slicer values. So the what value measure will get can not be used.
Just see how can you use measure