Forum Discussion
NithinBN
Helper II
Helper IICount based on vales present in 2 table
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!
We can count the unique entries in Table 1 filtered by table 2 like this.
Count Measure = CALCULATE ( DISTINCTCOUNT ( Table1[ID-1] ), Table2 )
1 Reply
- jdbuchanan71
Super User
We can count the unique entries in Table 1 filtered by table 2 like this.
Count Measure = CALCULATE ( DISTINCTCOUNT ( Table1[ID-1] ), Table2 )