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.

     

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.