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.

     

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 

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    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.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    I believe your question has already been answered.