Matrix is showing unexpected result..

[Chris64]

I had 3 tables. Each table contains one xxxx-ID column, which acts as key. Table 1 only contains unique values of xxxx-ID, while table 2 and 3 contain multiple occurences xxxx-IDs (duplicates). Table 2 for instance has a column called 'action' with about 20 different actions. An xxxx-ID can have more than one action, but an action always has one of the same xxxx-ID. 

As I need to do some data validation I wanted to check how many of the xxxx-IDs from table 1 are also in table 2, for each 'action'. So I created a matrix visual. However, since I the results I got didn't make much sense, I added a new table (table 4) which contains a single column that has a single instance of all xxxx-ID in all three tables (so only unique xxxx-IDs).

Then, I created a new matrix visual to count the number of xxxx-ID per 'action' as shown below:

As you can see, the numbers still don't make sense. For each 'action' it shows the count of all the xxxx-ID's in table 4. While some actions occur with just a couple of dozen xxxx-ID's.

My relationships looks like this. Basically I have table 4 connected to the three other tables by key xxxx-ID (marked yellow):

[Greg_Deckler]

Well, unfortnately, because you blurred everything out, it's impossible to figure out what is related to what and correlate that back to your results. Or, you have created a relationship that doesn't make any sense. You shouldn't need a fourth table. 

Tough to really say without sample data, etc. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Chris64]

You've got a point there... With the screens I tried to give as much info, without exposing sensitive data. I'll see if I can add some sample data.

[v-jiascu-msft]

Hi @Chris64,

Since all the IDs in the table2 are in the table1, it seems the answer is the count of IDs in the table2. Right?

Best Regards,
Dale