Count on various Columns between tables

Team i need your great Help,

for the following Scenarion:

Table 1   Contains a ID, Number, Country

Table 2   Contains also the Number, and Countries and a Qty.

Demand on this Request is, i need a Setup which contains:

From Table 1 : Distinct Count of ID, Number, Country ----- From Table 2 : In-Country verification, out-Country Verification , total Qty per in and out Verification

Country Verification means : T1 has   AU, AR, BR, US based on Number

T2 could have AU, DE, BR, GB on the same Part Number

there are multiple same numbers and countries on both Tables, the ID in Table 1 should be the Count here.

Currently i have a active Connection betwenn Number - Number - with Cross Filter Direction Both

and between country as inactive. 

Based on this i tried to solve it with userrelationship 

Any Support how i can solve this Issue ?