1 of 1 people found this helpful
Setup two parameter to switch between A/B/C and D. Then, create two calculated fields that returns the correct value based on the parameter selection.
WHEN 'A' THEN [A]
WHEN 'B' THEN [B]
WHEN 'C' THEN [C]
WHEN 'D' THEN [D]
Hope this helps!
Can you please explain how to change the number of selection in measure values by above approach.
I want my rows shelf have dynamic number of values based on the selection.
So I am taking measure values and want it to dynamically change its values everytime I change parameter values.
Ohhh, so [A] to [D] would also have [A], [B], and [C]?
If so, you can combine with an if statement:
IF [From] = 'A' AND [To] = 'D'
THEN [A] + [B] + [C] + [D]
ELSEIF [From] = 'A' AND [To] = 'C'
THEN [A] + [B] + [C]
ELSEIF [From] = 'A' AND [To] = 'B'
THEN [A] + [B]
You can, of course, combine these multiple ways - for example if you wanted to add commas between them and treat them like strings, maybe you need something like this:
STR([A]) + " , " + STR([B])