Forum Discussion
Conditional column Based on Switch function - Error
- 3 years ago
Hi SriGaG1 ,
You can add a measure to the visual:
Measure = VAR _a = SWITCH ( MAX ( Parameter[Parameter] ), "Overall", MAX ( 'Table'[Customer overall Satisfaction Rating] ), "Safety", MAX ( 'Table'[Customer Safety Satisfaction Rating] ) ) VAR _b = SWITCH ( _a, 1, "dissatisfied", 2, "dissatisfied", 3, "neutral", 4, "satisfied", 5, "satisfied" ) RETURN _bFinal output:
Besides, this question is beyond the original topic of this thread, so if you still have any other questions, please consider marking the responses that are helpful to you and creating a new thread in order to better help others with similar questions. This will make the post more relevant and will allow more people to help you!
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mikelytics Thank you very much for your answer. Its not workin actually. I have tried that one too 😞
SriGaG1 @Can you please show a picture of the data model? Do you added a relationship? If yes, you have to remove the relation.
Best regards
Michael