Forum Discussion
Solved
One to Many Relationship
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!
= COUNTROWS( FILTER( 'Table 1', ISEMPTY( CALCULATETABLE( 'Table 2' ) ) ) )
1 Reply
= COUNTROWS( FILTER( 'Table 1', ISEMPTY( CALCULATETABLE( 'Table 2' ) ) ) )