topic Re: Add column if at least 1 answer out of 6 is true in DAX Commands and Tips

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

Anonymous — Tue, 14 Jun 2022 08:48:52 GMT

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?

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

tamerj1 — Tue, 14 Jun 2022 09:20:02 GMT

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" )

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

Anonymous — Tue, 14 Jun 2022 09:28:46 GMT

Yes, right one, thanks a lot!