Add column if at least 1 answer out of 6 is true

[Anonymous]

I have a table like: 

person_id	question_code	answer	yes/no
123	1q	yes	yes
123	2q	no	yes
123	3q	no	yes
123	4q	no	yes
123	5q	no	yes
123	6q	no	yes

So, each person is asked 6 questions, and if at least one answer out of 6 is "yes", then new column (yes/no) should show all "yes" per this person. If all answers are "no", then new column(yes/no) should show all "no" per this person.
How to create this column on dax?

[tamerj1 · Accepted solution]

Hi @Anonymous 

Please use

=
VAR CurrentIDTable =
    CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[person_id] ) )
VAR Answered =
    SELECTCOLUMNS ( CurrentIDTable, "@Answered", TableName[Answer] )
RETURN
    IF ( "Yes" IN Answered, "Yes", "No" )

[Anonymous]

Yes, right one, thanks a lot!