Forum Discussion
Reference to a Field Parameter: Calculate(Selectedvalue(Parameter'[Parameter]), ...)
- 1 year ago
I use a similiar solution to bhanu_gautam , with a few differences that allows a little more customization:
Selected Measure = SWITCH( SELECTEDVALUE( 'All Periods Parameter'[All Periods Parameter Fields] ), NAMEOF('Measures for Parameter_all Periods'[25 ACT MTD P01 Ø]), 'Measures for Parameter_all Periods'[25 ACT MTD P01 Ø], NAMEOF('Measures for Parameter_all Periods'[25 ACT MTD P02 Ø]), 'Measures for Parameter_all Periods'[25 ACT MTD P02 Ø], NAMEOF('Measures for Parameter_all Periods'[25 ACT MTD P03]), 'Measures for Parameter_all Periods'[25 ACT MTD P03] )You can also wrap the returned measure in a FORMAT() function to control the format directly of the returned value, and you can add additional measures if needed.
- 1 year ago
Anonymous, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Alex_Sawdo & bhanu_gautam Thanks for your prompt response
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Anonymous, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Alex_Sawdo & bhanu_gautam Thanks for your prompt response
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query