Count based on vales present in 2 table

[NithinBN]

Hello Team, 

I have 2 tables  having 1 to * relationship, like this, 

How can can i get list of ID-1 (Table-1) having a occurance at Value column (Table -2)

In this example I need result as 3.

Thank you!

[jdbuchanan71 · Accepted solution]

We can count the unique entries in Table 1 filtered by table 2 like this.

Count Measure = CALCULATE ( DISTINCTCOUNT ( Table1[ID-1] ), Table2 )