Forum Discussion

powerbisach's avatar
powerbisach
Helper I
6 years ago
Solved

set Multiple values in visual filter

I have a user table where user is mapped to countries User Country State email ABC IN     XYZ   MH   DDD MU     DDD PU     Based on user login email i get the assoc...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi powerbisach ,

     

    Modify the measure like:

    Measure = if(SELECTEDVALUE(Country[Country]) in VALUES(User[Country]),"yes","no")

    Result would be shown as below.

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

powerbisach's avatar
powerbisach
Helper I
6 years ago

 v-jayw-msft - The 2 tables are disconnected. Your solution works when i set up a relationship between these 2 tables. When there is no relationship the visual shows no result. 

  • DouweMeer's avatar
    DouweMeer
    Impactful Individual
    6 years ago

    powerbisach 

    Do you also get "No" values when the statement doesn't return "Yes"?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi powerbisach ,

     

    Modify the measure like:

    Measure = if(SELECTEDVALUE(Country[Country]) in VALUES(User[Country]),"yes","no")

    Result would be shown as below.

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.