Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Selectedvalue with bracked

Hi Experts

 

How can i add brackets on to the following dax measure

 

Measure = 

SelectedValue = SELECTEDVALUE('pg_control_cases'[country_dim.country_name])
 
expected end result = - (canada)
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    Not entirely sure what you mean, do you want brackets around the result returned by the measure?

     

    If so, use this

     

    Measure = "(" & SELECTEDVALUE('pg_control_cases'[country_dim.country_name]) & ")"

     

    If you also need a - before the ( just add that into my code.

     

    regards

     

    Phil

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi Anonymous 

     

    Not entirely sure what you mean, do you want brackets around the result returned by the measure?

     

    If so, use this

     

    Measure = "(" & SELECTEDVALUE('pg_control_cases'[country_dim.country_name]) & ")"

     

    If you also need a - before the ( just add that into my code.

     

    regards

     

    Phil