First Time Pass Count

[Anonymous]

I am trying to figure out how to get a count on the number of products that passed thier test on the first run. So I want a count of the rows where the first value in the status column is "Passed". Example selection below 

DATE		USER		SN				Pass/Fail
4/5/2022 8:15		53209		22032722		28		Passed
4/5/2022 8:16		53209		22032679				Failed
4/5/2022 8:17		53209		22032679				Failed
4/5/2022 8:17		53209		22032679		27		Passed
4/5/2022 8:19		53209		22032676		28		Passed
4/5/2022 8:20		53209		22032707		27		Passed
4/5/2022 8:23		53209		22032955				Failed
4/5/2022 8:23		53209		22032955		28		Passed
4/5/2022 8:24		53209		22032945				Failed
4/5/2022 8:24		53209		22032945		28		Passed
4/5/2022 8:26		53209		22032866				Failed
4/5/2022 8:26		53209		22032866		28		Passed
4/5/2022 8:27		53209		22032704		28		Passed
4/5/2022 8:39		53209		None				Not Tested
4/5/2022 8:40		53209		None				Not Tested
4/5/2022 8:40		53209		22044387		27		Failed
4/5/2022 8:41		53209		22044387		27		Passed
4/5/2022 8:42		53209		22044388		28		Passed
4/5/2022 8:43		53209		22044389				Failed

Any help is greatly appriciated. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please refer to my pbix file to see if it helps you.

Create a column first.

Column 2 _passed =
CALCULATE (
    MIN ( 'Table'[Pass/Fail] ),
    FILTER (
        'Table',
        'Table'[DATE] = EARLIER ( 'Table'[DATE] )
            && 'Table'[SN] = EARLIER ( 'Table'[SN] )
    )
)

Then create a measure.

Measure_count =
VAR _mindate =
    CALCULATE (
        MIN ( 'Table'[DATE] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[USER] = SELECTEDVALUE ( 'Table'[USER] )
                && 'Table'[SN] = SELECTEDVALUE ( 'Table'[SN] )
        )
    )
RETURN
    CALCULATE (
        COUNT ( 'Table'[Column 2 _passed] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Column 2 _passed] = "Passed"
                && 'Table'[DATE] = _mindate
        )
    )

If I have misunderstood your meaning, please provide your desired output with a screenshot.

Best Regards

Community Support Team _ Polly

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