Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
johnyip
Super User
Super User

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

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.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!
2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

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

View solution in original post

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.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

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.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.