Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Help with a SELECTEDVALUE formula

I need to be able to reference in a SELECTEDVALUE to any of these fields in the parameter group.

This is the parameter of fields:

This is the formula I need to fix:

I would need to know how to reference well to the parameter within the formula.

Thanks in advance

2 Replies

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    3 years ago

    Hi  what I usually do instead of using data groups in fiel parameters is to change a bit the code on the parameters itself to manually generate the group like this: 

     

     

    Field Param Example = {
    ("Country", NAMEOF('Customers'[Country]), 0, "Group 1"),
    ("Region", NAMEOF('Customers'[Region]), 1, "Group 1"),
    ("City", NAMEOF('Customers'[City]), 2, "Group 1"),
    ("Address", NAMEOF('Customers'[Address]), 3, "Group 1"),
    ("Country", NAMEOF('Customers'[Country]), 0, "Group 2"),
    ("Region", NAMEOF('Customers'[Region]), 1, "Group 2"),
    ("City", NAMEOF('Customers'[City]), 2, "Group 2")
}

     

     

    Syndicate_Admin

     

    This way I think its easier to use the SELECTEDVALUE() function on the field parameter itself.

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes