Forum Discussion
Select values based on selection from non-related table
oddarin ,
It is possible. Can you please provide some sample data and expected output in the expected visual?
Thanks,
Arul
Arul Thank you for the reply!
I have that kind of data
And I expect if I select vendor code in the first table, in second I'll see all orders with that vendor code
So the main task is to pass the value of the selected code to use it for the filtration in the second table as if that two tables have actual relationship by vendor code (which they don't have)
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 _resultThanks,
Arul
This worked perfectly for me thanks
2 years later, this post is still helpful.
