Forum Discussion
Infidti
3 years agoFrequent Visitor
SWITCH(SELECTEDVALUE
I am creating a grouping for my measures to show them in a different way like in excel for a table visual. Currently it times out as I believe it's to big, is there anyway I can optimize the foll...
Kishore_KVN
3 years agoSolution Sage
Hello Infidti , If multiple measures take similar value then create using OR statement to reduce number of iterations. For example
Switch(Selected Value(Measures),
"Name1"||"Name2"||"Name3", Measure1,.....
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!