Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help - Referencing columns from a different table while using Direct Query.

Hi,   I have two tables, a student table and a family table.    The student table is as follows, where Student ID is the primary Key.   Student ID FamilyID 1 F001 2 F002 3 F003 ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    First check the data type of Phone column in the query editor to ensure that the blank field is null.

    Then create a measure like below:

    Measure 2 = COUNTROWS(FILTER(Family,ISBLANK(Family[Phone])))+0

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

You need a calculated column in DAX, right? this table is called Table1, your other table is called Table2 in my sample

Column = 
VAR CurFamilyID=Table1[FamilyID]
VAR T1=CALCULATETABLE(Table2,Table2[FamilyID]=CurFamilyID)
RETURN
COUNTROWS(T1)-COUNTROWS(FILTER(T1,[Phone]<>BLANK()))