IF Function with multiple conditions

Idonotknowthis 

output 

calculated column : 

Column = 
var ds = 
FILTER(tbl_2,
tbl_2[CaseID] = tbl_1[CaseID] && (tbl_2[TypeOfBug] = "nontech" || tbl_2[TypeOfBug] = "reqtype")) 

RETURN
if( ISEMPTY(ds), "NO", "YES")

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅ to help other people to find it more quickly . 

Hi Idonotknowthis ,
Daniel29195 Great solution, here's mine.

AssociatedReq = 
IF(
    CALCULATE(
        COUNTROWS(Table2),
        FILTER(
            Table2,
            Table2[CaseID] = EARLIER(Table1[CaseID]) &&
            (Table2[TypeOfBug] = "nontech" || Table2[TypeOfBug] = "reqtype")
        )
    ) > 0,
    "Yes",
    "No"
)

Final output

Best regards,

Albert He

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