Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
Solved

Change column based on selection

Hi,

 

I need help to create a measure that allow me to change column based on the selection.

I created the following but not sure if the logic is correct:

 

Category Selection =
SWITCH(TRUE(),
SELECTEDVALUE(Category[Category])="Market",SELECTEDVALUE('List MU'[Market]),
SELECTEDVALUE(Category[Category])="Market Unit",SELECTEDVALUE('List MU'[Market Unit]),
SELECTEDVALUE(Category[Category])="Client Classification",SELECTEDVALUE('List Master Client'[Client Classification]),
SELECTEDVALUE(Category[Category])="CG",SELECTEDVALUE('List CG'[CG]),
SELECTEDVALUE(Category[Category])="SG",SELECTEDVALUE('List SG'[SG]),
SELECTEDVALUE(Category[Category])="FY&Q",SELECTEDVALUE('Calendar'[FY & Q]),
SELECTEDVALUE(Category[Category])="Month",SELECTEDVALUE('Calendar'[Month Name]))
 
Category Column:

 

Hope you can help me.

Thanks.

 
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

1 Reply