Forum Discussion

Bootkie2's avatar
Bootkie2
Frequent Visitor
6 years ago
Solved

Help with This &&& || Statement

I have a really dumb question. I have a table with a UserId a Question Id and an Answer. I'm trying to call out user Ids who answered "No" to q_1 But they must have  said "Yes" in either q_2, q_3, or...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Create a table

    TableU = INTERSECT(
    SELECTCOLUMNS(FILTER(TableD, TableD[Qid] = "q_1" && TableD[Answer] = "No"),"user", TableD[userID]),
    SELECTCOLUMNS(FILTER(TableD, TableD[Qid] in {"q_2", "q_3", "q_4"} && TableD[Answer] = "Yes"),"user", TableD[userID]))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Bootkie2's avatar
Bootkie2
Frequent Visitor
6 years ago

Thanks so much. All of these solutions worked well but the INTERSECT was the easiest to achieve what I was trying to do. I wasn't aware of of that code until now. Very useful. Thanks again everyone.