Forum Discussion
Select values based on selection from non-related table
Hi, I wonder if is it somehow possible to select values from table based on value from non-related table (or, in fact, related but not in a way needed in that task)? I mean I have one table with so...
oddarin ,
Based on my research so far I have achieved it through measure which you need to apply at visual level, before selection the visual will be blank but if you select any code in table it will display in table.
Interaction =
VAR _values = VALUES('List 2'[Value])
VAR _result = IF(SELECTEDVALUE('List 1'[Value]) IN _values,1,0)
RETURN _result
Thanks,
Arul
2 years later, this post is still helpful.