Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Index 1 |
Index 2 |
Index 3 |
Solved! Go to Solution.
Hi @Anonymous ,
You need to redo your measure to the following:
Cumulative Growth =
EXP (
SUMX (
FILTER ( ALL ( Rates ), Rates[Year] <= MAX ( Rates[Year] ) ),
VAR Index_Selection =
SELECTEDVALUE ( Table[IndexSelected] )
RETURN
LN (
1
+ SWITCH (
Index_Selection,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
You need to redo your measure to the following:
Cumulative Growth =
EXP (
SUMX (
FILTER ( ALL ( Rates ), Rates[Year] <= MAX ( Rates[Year] ) ),
VAR Index_Selection =
SELECTEDVALUE ( Table[IndexSelected] )
RETURN
LN (
1
+ SWITCH (
Index_Selection,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks,
helped a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |