Using Keepfilters on two different tables.

[dicken]

Hi all,
I've been trying to use two 'internal ' filters on two different tables, I think I've got it working;



<
< CALCULATE([total Sales Revenue],KEEPFILTERS(Product[Color]="Red"), KEEPFILTERS(Sales[Units Sold]= 10 ) ) >


When I've been using the two columns on the same table I've been able to use a :



< Wrapped in Keep:=CALCULATE([Sales Revenue],

KEEPFILTERS(( FILTER(ALL('Product'[Color],'Product'[Product]),

'Product'[Product]= "A" && 'Product'[Color]= "Red") ) )) >

Is there something similar I can do rather than rather than using two keepfilters?
Directions to any helpful sites or video's much appreciated.

Richard.