Solved: One to Many Relationship

nlakshmi · ‎06-07-2022

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 · ‎06-07-2022

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

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

CNENFRNL · ‎06-07-2022

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

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!