Forum Discussion

joep78's avatar
joep78
Helper III
6 years ago
Solved

Insert value based on different columns

Hi there,   I’m relatively new using PBI and hopefully somebody can help me figuring out how to write a DAX statement.   My table name is ‘AnswerLine’ and within this table I’ve got a question co...
  • natabird3's avatar
    natabird3
    6 years ago

    @joep78 

    Maybe try this primitive solution:

    Measure = IF(CONTAINS(AnswerLine,AnswerLine[Answer],"Y"),1,0)
    Measure 2 = COUNTX(AnswerLine,"Y")
natabird3's avatar
natabird3
Skilled Sharer
6 years ago

@joep78 

Maybe try this primitive solution:

Measure = IF(CONTAINS(AnswerLine,AnswerLine[Answer],"Y"),1,0)
Measure 2 = COUNTX(AnswerLine,"Y")
  • joep78's avatar
    joep78
    Helper III
    6 years ago

    Thanks for your reply, the following solutions based on your answer works for me:

    Measure= IF(
    AND(
    OR(
    CONTAINS(BaseORderAnswerLine;BaseORderAnswerLine[answer];"Ja";BaseORderAnswerLine[Question];"ONG000.04");
    CONTAINS(BaseORderAnswerLine;BaseORderAnswerLine[answer];"Ja";BaseORderAnswerLine[Question];"ONG000.05"));
    CONTAINS(BaseORderAnswerLine;BaseORderAnswerLine[answer];"Ja";BaseORderAnswerLine[Question];"ONG020")
    )
    ;1;0)

     

    with this, I have the right meausure output!