topic Unable to return Value from measure to Calculated Column in DAX Commands and Tips

Unable to return Value from measure to Calculated Column

Anonymous — Thu, 03 Sep 2020 13:53:25 GMT

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

Re: Unable to return Value from measure to Calculated Column

Greg_Deckler — Thu, 03 Sep 2020 14:13:09 GMT

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.

Re: Unable to return Value from measure to Calculated Column

amitchandak — Thu, 03 Sep 2020 14:45:08 GMT

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