Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a dynamic text field in DAX

I'm wondering if it is possible to create a dynamic text field in DAX that changes value based on a SWITCH statement. I know this is possible to do with calculated columns, but this will not be dynam...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You can enable Q&A . and post that you can add the measures to your text box, you will get a + value option

 

You can have measure like selectedvalue(Table[Country]) , Sum(Table[Sales])  etc and use that

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the reply.

 

I'm not looking to change a field in a text box, rather a text column in the dataset. 

 

For example, the table below. I've created a disconnected table with only the text values "Project", "Continent", "Sub Region", and "Country". I have a slicer on the dashboard that allows the user to select one of these 4 text values. What I'm trying to do is have a text field that changes based on what the user selects in the slicer using a SWITCH statement. E.g. SWITCH(SELECTEDVALUE([Disconnected Table Field]), "Project", [Project], "Continent", [Continent], ...)