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

     

V-lianl-msft's avatar
V-lianl-msft
Community Support
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