Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
Hi @Gleb
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" )
Hi @Gleb
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" )
Yes, right one, thanks a lot!
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |