Forum Discussion
powerbisach
6 years agoHelper I
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...
- Anonymous6 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.
DouweMeer
6 years agoImpactful Individual
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
6 years agoHelper I
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.