Forum Discussion

jdriscoll's avatar
jdriscoll
Helper I
3 years ago
Solved

Returning List of Rows without Associated Values in Another Table

Hi,   I have a table with a list of people in my group and a linked table with columns of people and their responses to a survey (if the person has responded). How do I create a calculated table th...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi jdriscoll ,

     

    I have modified your measure:

    Remaining_Respondents = IF(COUNTX(Score_Table, Score_Table[Email]) = 0, 1)

    Then create a table use column Name and apply the measure to the visual level filter:

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi jdriscoll ,

 

Since the sample you provided is out of date, I created a simple sample based on your description:

Please try:

 

Table 2 = SELECTCOLUMNS(FILTER('Linked Table',ISBLANK([Response])),"Person",[Person])

 

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.