Forum Discussion
Get a table with comments
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 MAX() - is work, but this is not the answer to my question. I need to display comments for questions that are "not ok", not only the questions themselves. Sorry, for the russian words. If I use your measure I will see Title contains only questions.
I want to get visal like this:
Each filled form has its own FormFilled id. Question id Questions from the FormQuestions table are attached to it. 1654 - comment (also called in Russian) 1653 - a question to which the answer "not ok" was received. I want to leave only the lines with questions that are answered with "not ok" and that also have a comment filled in. The number at the beginning of the wording of the question and the comment is the link between them. If the question starts with the number 9, then the comment on this question also starts with the number 9
Community ChampionHi,
I see, in that case something like this should work:
data:
Dax:
End result: