Cloning an entire column based on the value of a measure / (single) selected value of a slicer

[johnyip]

How can I create a column, probably a calculated column, using DAX to clone an entire column based on the value of a certain measure or the selected value of a slicer?

For example, when I select "A" in a slicer, the measure will become 1; when I select "B" in a slicer, the measure will become 2.

What I want to achieve is to clone the entire "column A" to the new column when I select "A" in the slicer, and clone "column B" to the new column when "B" is selected in the slicer. The values contained in that new column are responsive to the change of selection of trhe slicer / measure.

Thank you.

[amitchandak · Accepted solution]

@johnyip , You can not create a new column using selectedvalue of the slicer.

You can only have measure

Switch(True(),

selectedvalues(Table[Column]) ="A",1 ,

selectedvalues(Table[Column]) ="B",2 ,

3)

[amitchandak · Accepted solution]

@johnyip , You can not create a new column using selectedvalue of the slicer.

You can only have measure

Switch(True(),

selectedvalues(Table[Column]) ="A",1 ,

selectedvalues(Table[Column]) ="B",2 ,

3)

[johnyip · Accepted solution]

Thanks for the reply. Enlighened by your reply, I think I have to use SWITCH() for every of my DAX to select the appropriate column for the calculation. This is rather clumsy but seem to be the only way as of now.