set Multiple values in visual filter

[powerbisach]

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 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.

[powerbisach]

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.

[powerbisach]

 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. 

[Anonymous · Accepted solution]

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.

[DouweMeer]

@powerbisach 

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

[Anonymous]

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. 

[DouweMeer]

@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

[DouweMeer]

@powerbisach 

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?

[powerbisach]

DouweMeer

 Yes...Based on user country field the visual should display details from country table related to it. This can not be done using RLS (due to business constraints) and need to apply visual filter only.

[Greg_Deckler]

Can you share your formula?

[powerbisach]

 Greg_Deckler

It's a simple formula applied in measure user country =

IF(VALUES(user[country])=VALUES(country[country]),"Yes","No")