Unable to return Value from measure to Calculated Column

[Anonymous]

Hi All,
         Must be a simple fix for pro users like you..My Measure is as here 

'Measure
dYNAMICMEASURE = SWITCH(SELECTEDVALUE('Table'[Value]),

15,14,

30,29,

45,44,

60,59,

59)

'Calculated Column

testpiece = [dYNAMICMEASURE]


The above testpiece returns 552004 ?

May i know how i can overcome this problem


Thanks a ton

[Greg_Deckler · Accepted solution]

@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 · Accepted solution]

@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

[Greg_Deckler · Accepted solution]

@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.