Count text occurrences in table by item

[Anonymous]

I'm new to PowerBI and for the life of me I can't seem to find the answer for this.

I'm looking for a count of all "passes" and "fails" by studentID. 

I would like to display the results in a stacked column chart. I've attempted measures, but they all return the same result for all the students, whereas I want the unique results per student.

STUDENT-ID                     RESULT

student01                           pass

student01                           pass

student01                           fail

student02                           pass

student02                           pass

Any help would be greatly appreciated!

[zivhimmel · Accepted solution]

should be something like that:

new_measure_name=CALCULATE(count([RESULT]),RESULT="pass")

[Anonymous]

That does it! Thanks for the fast reply, that was quick!!!