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 ...
We can count the unique entries in Table 1 filtered by table 2 like this.
Count Measure = CALCULATE ( DISTINCTCOUNT ( Table1[ID-1] ), Table2 )
jdbuchanan71
Super User
Super UserWe can count the unique entries in Table 1 filtered by table 2 like this.
Count Measure = CALCULATE ( DISTINCTCOUNT ( Table1[ID-1] ), Table2 )