Counting consecutive fails in test results

I have a table containing test results. The test results contain Buildnr, TestCase name and TestCase results. I want to create a new measure or a new column which calculates how many times a ...