DAX Filter by values found in a column of another table

[dicken]

I hope this illustrates what I would like to do i fist have a virtual table filtered for just green products, and then a second
for just red , I would like to filter the second table to show only customers or whatever that are contained in the first;

EVALUATE
VAR ttable =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer], Table1[Product], Table1[Color] ),
Table1[Color] IN { "Red" }
)
VAR ttabletwo =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer], Table1[Product], Table1[Color] ),
Table1[Color] IN { "Green" }
)
RETURN
ttabletwo



So this ttabletwo should be filtered to only those customers who appear in ttable,
I'm stuck on even the syntax and can't find much information about how I can refer to the first table I've tried
various such as ttable [Customer] , "Customer" etc. So direction to any information on this would be helpful.
Richard.

 

[RoryA]

If you make ttable a one column table of the items, then you should be able to use it in an IN clause in a filter - something like:

EVALUATE
VAR ttable =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer]),
Table1[Color] = "Red"
)
VAR ttabletwo =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer], Table1[Product], Table1[Color] ),
Table1[Color] = "Green"
)
RETURN
FILTER(ttabletwo,[Customer] IN ttable)

 

[dicken]

If you make ttable a one column table of the items, then you should be able to use it in an IN clause in a filter - something like:

EVALUATE
VAR ttable =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer]),
Table1[Color] = "Red"
)
VAR ttabletwo =
CALCULATETABLE (
SUMMARIZE ( Table1, Table1[Customer], Table1[Product], Table1[Color] ),
Table1[Color] = "Green"
)
RETURN
FILTER(ttabletwo,[Customer] IN ttable)

Thanks for the response, I was getting close, and put up a post on forum, linked, as you have I was using summarize to get a one column table but as a separate variable, did not get it to work but at least it looks like I was going in the right direction.

RD