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 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!

Need Help

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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.

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    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.

  • jdriscoll's avatar
    jdriscoll
    Helper I
    3 years ago

    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