cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## 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 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)?

1 ACCEPTED SOLUTION
Community Support

Hi @jdriscoll ,

``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.

7 REPLIES 7
Helper I

Hi all,

@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.

Super User

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

Hi @jdriscoll ,

``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.

Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

Hi @jdriscoll ,

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

``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.

Super User

@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.

Helper I

Hi,

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors