cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akmp Frequent Visitor
Frequent Visitor

Counting consecutive fails in test results

I have a table containing test results.

The test results contain Buildnr, TestCase name and TestCase results.

image.png

I want to create a new measure or a new column which calculates how many times a testcase has failed in a row.

e.g if i specify Build and TestCase it should show that the Test Case has failed x times in a row.

Build 125

TC_1 -> 3 fails in a row

TC_2 -> 2 fails in a row

TC_3 -> first failure

TC_4 -> No fails

 

One solutions would be to create a new table where which contains a matrix where the columns are TestCase names and The Rows Build_nr.  But i do not know how to do that.

 

What is the prefered way to find consecutive failures?

1 ACCEPTED SOLUTION

Accepted Solutions
Akmp Frequent Visitor
Frequent Visitor

Re: Counting consecutive fails in test results

2 REPLIES 2
Community Support Team
Community Support Team

Re: Counting consecutive fails in test results

Hi @Akmp ,

 

You can create a new calculated column to mark the “Fail” and “Pass”.

Column 2 =
VAR a =
    CALCULATE (
        COUNTROWS ( FILTER ( test, test[Result] = "fail" ) ),
        ALLEXCEPT ( test, test[TestCase], test[Build] )
    )
RETURN
    IF ( a = BLANK (), 0, a )

Then you can refer to this case which is similar to yours.
https://community.powerbi.com/t5/Desktop/DAX-how-to-count-consecutive-identical-values/td-p/701936

 

Best Regards,

Eads

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Akmp Frequent Visitor
Frequent Visitor

Re: Counting consecutive fails in test results

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 182 members 2,395 guests
Please welcome our newest community members: