Returning List of Rows without Associated Values in Another Table

[jdriscoll]

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 that has a single column of rows of people who haven't responded to the survey (i.e., they don't have a value in the survey response table)?

Thanks in advance!

[jdriscoll]

Hi all,

To address the above replies:

@Ashish_Mathur , the solution does not need to be a calculated table. In fact, I made an attempt at a measure that is pretty close, but still requires some workarounds that I'm not thrilled with (see link to sample file below).

@v-jianboli-msft, I tried out your measure and couldn't get it to work in my file. I've copied a new link in to my file that shouldn't expire this time.

Thanks all for your help so far.

Link to BI 

[Ashish_Mathur]

I believe your question has already been answered.

[v-jianboli-msft · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Is there a specific reason to create a calculated table?  Why not a measure?  If you want a measure solution, then share the download link of th PBI file or share data in a format the can be pasted in an MS Excel file.

[v-jianboli-msft]

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.

[amitchandak]

@jdriscoll , concatenatex can help

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[jdriscoll]

Hi,

Please see this link for file.