One to Many Relationship

[nlakshmi]

Hi Comunity,

Apologize if this has been discussed earlier, I could not find a thread.

I have 2 tables (mockup data):

Table 1

Product ID

P1

P2

P3

P4

Table 2

Product ID	Mfg Year
P2	2020
P2	2019
P3	2021

How can I count the number of Product IDs that do not have a Mfg Year in Table 2 - in this case would be 2 (P1, P4)?

Thank you in advance!

[CNENFRNL · Accepted solution]

= COUNTROWS( FILTER( 'Table 1', ISEMPTY( CALCULATETABLE( 'Table 2' ) ) ) )