Forum Discussion

nlakshmi's avatar
nlakshmi
Frequent Visitor
4 years ago
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...
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    = COUNTROWS( FILTER( 'Table 1', ISEMPTY( CALCULATETABLE( 'Table 2' ) ) ) )
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
= COUNTROWS( FILTER( 'Table 1', ISEMPTY( CALCULATETABLE( 'Table 2' ) ) ) )