Forum Discussion

rdg515's avatar
rdg515
Icon for Resolver I rankResolver I
4 years ago
Solved

Parameter: Fields selected value

I want to create a measure that references the selected value from a paramater table (create new parameter, select fields). I will show you the way I did it below, but I'm looking for an improvement ...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi rdg515 ï¼Œ

 

Please try the measure.

 

Selected Survey Avg Rating = 
SWITCH (
    SELECTEDVALUE ( prmSurveyResponses[prmSurveyResponses Fields] ),
    NAMEOF ( 'Service Survey'[NPSResponseCode] ), [NPS Avg Rating],
    NAMEOF ( 'Service Survey'[CustomerEffortResponseCodeText] ), [Customer Effort Avg Rating],
    NAMEOF ( 'Service Survey'[ProductCompetitionResponseCodeText] ), [Product Competition Avg Rating]
)

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Here is a more universal solution. 

     

    Selected Parameter = 
VAR SearchString = SELECTEDVALUE('Field Parameters'[Parameter])
VAR LeftBound = SEARCH("[",SearchString)
VAR RightBound = SEARCH("]",SearchString)
RETURN
MID(SearchString,LeftBound + 1,RightBound-(LeftBound+1))

     

    • Gibby_ngam's avatar
      Gibby_ngam
      Frequent Visitor
      1 year ago

      This works if you only want the text, not the measure 🙂.  This is perfect for me since I only want the display text, not the measures

       

    • avisingh's avatar
      avisingh
      Icon for Advocate IV rankAdvocate IV
      1 year ago

      Actually this does not work at all.

      SELECTEDVALUE('Field Parameters'[Parameter])


      Always returns the error as below:
      "Column [Parameter] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression."