Count if multiple conditions are fulfilled

[katto16]

Hey guys, so I have this kind of sample data, where I want to count the "retest pass" and "rework pass" in a day.

Basically, if any of the Part was changed and pass, it's a rework pass. If the whole line is duplicated, it's a retest pass. The reason why I mention the date because some parts that failed in previous days might appear again in the following days (see CC3)

If the Unit ID appears only once and pass, then it's not counted into any category. 

My first idea is to create variables for different conditions and when all the conditions are met, it will be counted as 1. But I'm lost at the part where I have to determine the change of Part while the Unit ID and the Date stay the same. I was thinking about the EARLIER function as well but it wasn't successful when I tried it out.

I already have a calculated column created for the other situation which is the first pass if it helps in any way. 

First Pass = 
VAR currentID = 'Table'[Unit ID]
VAR currentResult = 'Table'[Overall Result]
VAR CountofRows = COUNTROWS(FILTER(Table, Table[Unit ID] = currentID))
VAR ReturnCheck = IF(CountofRows = 1 && currentResult = "pass",1,0)
return ReturnCheck

Thanks in advance!

[ddpl · Accepted solution]

@katto16 

Hey here I assuming the second last row Result = Pass...

Create a calculated column as below...

Requirement = 

IF(
    COUNTX(FILTER('Table', 'Table'[Part A] = EARLIER('Table'[Part A])), 'Table'[Unit ID]) = 1 && 
    COUNTX(FILTER('Table', 'Table'[Part B] = EARLIER('Table'[Part B])), 'Table'[Unit ID]) = 1 && 
    COUNTX(FILTER('Table', 'Table'[Part C] = EARLIER('Table'[Part C])), 'Table'[Unit ID]) = 1 && 
    'Table'[Result] = "Pass",
    "First Pass",
    IF(
        COUNTX(FILTER('Table', 'Table'[Part A] = EARLIER('Table'[Part A]) && 'Table'[Part B] = EARLIER('Table'[Part B]) && 'Table'[Part C] = EARLIER('Table'[Part C])), 'Table'[Unit ID]) = 1 &&
        'Table'[Result] = "Pass",
        "Rework Pass",
        IF(
            COUNTX(FILTER('Table', 'Table'[Part A] = EARLIER('Table'[Part A]) && 'Table'[Part B] = EARLIER('Table'[Part B]) && 'Table'[Part C] = EARLIER('Table'[Part C])), 'Table'[Unit ID]) > 1 &&
            'Table'[Result] = "Pass",
            "Retest Pass"
        )
    )
)

[katto16]

Let me just tag the top users for more reach @amitchandak @mangaus1111 @Greg_Deckler @Jihwan_Kim @ddpl 
Appreciate for any help possible.