count number of entries where one attribute matches a table but another doesn't

[WonderCoding]

Hello,

So I have two tables, one with shipping information (departure country and arrival country)

Shipping

id	DepartureCountry	ArrivalCountry
1	BR	US
2	IT	PT
3	US	IT

And another with a list of European countries. 

I was able to get the count for the shipping arriving at Europe with a measure that in this example would return 2 for ids 2 and 3

CALCULATE(COUNT(Shipping[ArrivalCountry]),RELATEDTABLE(Europeanlist))

Now I want to be able to count the number of entries where they departed from a non-European country and arrived at a European country. In the example above the count would only return 1 for the id 3. The problem is that both the attributes are related to the same table so I would need to use USERELATIONSHIP to change the relation and a NOT(RELATEDTABLE()), but I cant manage to get it to work. Any ideas?

Thanks in advance 

[johnt75]

You could create a measure like

Shipped from non-Europe to Europe =
var euroCountries = ALLNOBLANKROW('European List'[country])
var nonEuroCountries = ALLNOBLANKROW('Non European List'[country])
return CALCULATE( COUNTROWS(Shipping), TREATAS( nonEuroCountries, Shipping[Departure country]),
TREATAS( euroCountries, Shipping[Arrival Country])
)

[amitchandak · Accepted solution]

@WonderCoding , If Europeanlist is not filtered (in Slicer or filter )

Try a measure like 

CALCULATE(COUNT(Shipping[ArrivalCountry]),filter(Shipping, not shipping[DepartureCountry] in values(Europeanlist[Country])  && shipping[ArrivalCountry] in values(Europeanlist[Country])   ) )