Forum Discussion

acs's avatar
acs
Regular Visitor
8 years ago

COUNTIF in DAX going haywire?

Hey folks. Have been bashing my brain on a problem and tried multiple help posts' solutions to no avail. I've have a fairly chunky set of data from a quiz (600k+ rows).   Each question has a [qu...
Need Help
jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Don't think I've ever used count, I'd just use countrows here. Make a measure Answered similar to your first one for your all questions bit, then for each of your right/wrong things, make a measure Right= calculate([Answered],[answer-score]=1) and similar for wrong answers