topic Re: I have to create a column in a table, whose value will be selected values from what if parameter in DAX Commands and Tips

I have to create a column in a table, whose value will be selected values from what if parameter

Anonymous — Mon, 06 May 2019 14:36:17 GMT

I have a Table1 and in that I need to create a custom column, whose value will be selected value from the 'what if' paramter

I tried to create a Parameter Value column, by using the dax

Parameter Value = SELECTEDVALUE(Parameter[Parameter])

But I am getting blank in that column. Can anyone please help me in resolving this issue.

Thanks in advance

Re: I have to create a column in a table, whose value will be selected values from what if parameter

parry2k — Mon, 06 May 2019 15:55:18 GMT

Anonymous please add this as a measure not column

Re: I have to create a column in a table, whose value will be selected values from what if parameter

Michiel — Mon, 06 May 2019 15:56:16 GMT

You cannot do this. The idea of a calculated column is that it's real data, and that means it doesn't respond directly to user input.

SELECTEDVALUE returns the parameter value only if one value is selected, but in a calculated column it sees all values, so it's only logical that you get blank values.

Instead, you should write a measure that does what you need.

Re: I have to create a column in a table, whose value will be selected values from what if parameter

Anonymous — Wed, 08 May 2019 08:04:44 GMT

As per business requirements we want it in a column. Is there any way to do it or it is not at all possible?