Forum Discussion
set Multiple values in visual filter
I have a user table where user is mapped to countries
| User | Country | State | |
| ABC | IN | ||
| XYZ | MH | ||
| DDD | MU | ||
| DDD | PU |
Based on user login email i get the associated country. Then this country user[country] is used in measure to check if it is equal to another country country[country] in visual filter with "Yes" and "No" option. The measure is set to Yes to show only applicable country data. This works fine for one to one mapping, but when a user is mapped to multiple countries i am getting multiple values passed error...Any solution, workaround would be appreciated.
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.
10 Replies
Can you share your formula?
It's a simple formula applied in measure user country =
IF(VALUES(user[country])=VALUES(country[country]),"Yes","No")
Depends a bit what kind of behavior you expect. Do you expect a Yes in the 'Country' table when one of the records in 'User' does have this [country] value?
Selectedvalue = DDD Country Check IN No MU Yes PU Yes blank No Like this?
Hi powerbisach ,
Try use SELECTEDVALUE() function instead of VALUE() function.
Like:
if(selectedvalue(user[country])=selectedvalue(country[country]),"Yes",blank)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.
Anonymous and Greg_Deckler
Stachu , I saw you were discussing blanks in an earlier post. Perhaps you know this one.
To not Hijack PowerBisach post I created another post :).
https://community.powerbi.com/t5/Desktop/Implicit-filters-remove-all-records/m-p/945184#M452965
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.
Do you also get "No" values when the statement doesn't return "Yes"?
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.
v-jayw-msft - Perfect...Much appreciated....If possible could you please let me know how selectedvalue and values works differently and what to use when that will be helpful.
