Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get a table with comments

Please help to get a table that displays comments to questions for which the user has chosen the answer "not ok" The tables are linked by the following fields: FormFilled[id] - FormsQuestionsSele...
Need Help
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    I see, in that case something like this should work:

    data:


    Dax:

    Measure  11= IF(contains(filter(all(Questions),Questions[QID]=MAX(Questions[QID])),Questions[Comment],"Not ok"),1,0)

    End result:

     



ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I assume your end goals is to have a visual of sorts and you don't want to have an actual calculated table? If this is the case, you can achieve this by using a visual level filter Table[Answer]="not ok" or by creating a filter measure with the same logic. Filter Measure = IF(FormsQuestionSelectedAnswers[Answer]="not ok",1,0) ->apply this to a visual where [Filter Measure] is 1. If you want to have and calculated table with the comments ping me with @.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!