Conditional filter - dynamic table

[Anonymous]

Hi,

I am working with one data set that has information on several states. For example: 

State	Var1	Var2
Iowa	x1	y1
California	x2	y2
Arkansas	x3	y3

In the report, I have a table with a filter for the state column, so I can only see the information for one state. I want my second table to display the information for another state based on the selection for table 1. For example, if table 1 is filtered for "Iowa", the second table should be for "California" whereas if table 1 is for "Arkansas", table 2 should be for "Iowa". 

Thank you for all your help! 

TPS-he data I'm working with is very large so a duplicate secondary reference table is not feasible. 

[Anonymous]

Thank you, this was very helpful! I'm going to have to use bookmarks because the logic isnt too straightforward but I will definitely use this!

[amitchandak]

@Anonymous , if you want to include /exclude values based on slicer then use an independent table for state and use that in measure

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE