How to create measure for 1-1 relationship

[JIED]

Hello,

Please helo me 🙂

I am new to PowerBI

I get this 2 tables, they are 1-1 relationship by ID2.

ID2 is the sub Id of ID1.

 I want to get the count of category by ID1.

How do I write the measure ?

Many thanks in advance for your help!

How to create measure for 1-1 relationship 

[eshwarramesh97 · Accepted solution]

@JIED  no dax is needed for this just drag table 1 id1 on row of matrix and table 2 category on column of matrix and in values drop id2 of any table and select as count

[amitchandak]

@JIED , Create a matrix ID1 from Table 1 and Category on the column from Table 2. And count of id 2 in values

[JIED]

@amitchandak Thank you for providing your answer!

Could you please kindly provide the DAX example please?

I appreciate your help!