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