Count on various Columns between tables

[PSG83]

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 ?

[Anonymous]

HI @PSG83,

According to your description, it seems like you do not provide enough information to help us clarify your situation and build sample data and test to code formula.
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523