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 @TTKL ,
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.
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!