Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Reference to a Field Parameter: Calculate(Selectedvalue(Parameter'[Parameter]), ...)

Dear community, I have created a field parameter, which contains period measures, e.g. "MTD", "YTD", "RunRate",...).  All Periods Parameter = {     ("25 ACT MTD P01 Ø", NAMEOF('Measures for P...
  • Alex_Sawdo's avatar
    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. 

  • v-prasare's avatar
    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