Hi, I'm having trouble with changing a column reference based on a slicer selection. The videos and questions, i've seen use SELECTEDVALUES and SWITCH(TRUE() to return an expression. but i cant seem to return a different slicer selection.
The measure i've trying to make change is
At the moment the formula, i have is this
Go to Solution.
Hi @Anonymous ,
You need to redo your measure to the following:
Cumulative Growth =
FILTER ( ALL ( Rates ), Rates[Year] <= MAX ( Rates[Year] ) ),
VAR Index_Selection =
SELECTEDVALUE ( Table[IndexSelected] )
+ SWITCH (
1, Rates[ Index 1 ],
2, Rates[ Index 2 ],
3, Rates[ Index 3 ]
If this does not work can you share a small sample of your data and expected result
Proud to be a Super User!
View solution in original post
Thanks, helped a lot.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.