How to find new (different) items from two columns in different tables?

[OC101]

Hi,

I am kind of new in Power BI, I have below question, could you please help?

There are Table 1 and Table 2.  Table 1 is the first test, and many parts are taken out after the first test, Table 2 is the 2nd test and some new parts were added in the test. Now I need to find out which parts are newly added parts in Table 2 (i.e. not tested in the first test).

There is no direct relationship between the two tables, because both tables are connected to another table (the total part number list) by Part number, The part numbers are in text type in both tables.

Table 1

Part Number	Voltage	Result
900-0008C0000003174	5.1	FAIL
900-0008C0000003374	3.9	PASS
900-0008B0000003383	3.5	PASS
900-0008C0000003384	3.2	PASS
900-0009C0000003387	4.8	PASS
900-0008C0000003389	4.9	PASS
900-0007C0000003390	5.7	FAIL
900-0008C0000003392	6.1	FAIL
900-0008C0000003394	4.3	PASS
900-0007B0000003395	3.8	PASS
900-0008C0000003396	2.3	PASS
900-0008B0000003397	7.2	FAIL
900-0007C0000003398	2.4	PASS
900-0008C0000003399	1.8	PASS
900-0007B0000003401	3.6	PASS

Table 2

Part Number	Voltage	Result
900-0008C0000003374	3.9	PASS
900-0008B0000003383	3.5	PASS
900-0008C0000003384	3.2	PASS
900-0009C0000003387	5.9	FAIL
900-0008C0000003389	4.9	PASS
900-0008B0000003181	3.6	PASS
900-0008C0000003399	1.8	PASS
900-0007B0000003401	3.7	PASS
900-0008C0000003394	4.5	PASS
900-0007B0000003395	3.8	PASS
900-0008C0000003396	2.3	PASS
900-0007B0000001326	4.4	PASS
900-0007C0000003398	2.4	PASS
900-0007B0000001149	5.8	FAIL
900-0007C0000001891	3.6	PASS

[vicky_]

My data model looks like the following, although i suspect that your table will have 1:M instead of 1:1

Assuming you want your result as a DAX measure:

Newly Added = COUNTROWS(
    EXCEPT(VALUES('Table 1'[Part Number]), VALUES('Table 2'[Part Number]))
)

which gives the following result:

[OC101]

Hi vicky_,

Thanks for your reply! Besides the number of new parts, I also need to know the Part Numbers of the new parts.

[OC101 · Accepted solution]

Thanks vicky_! It works.