DAX: Return Result if Value in Column A matches Value in Column B

[mrbuttons07]

Hello everyone,

I want to return result if value from Column A matches with Value from Column B but with conditions. For example,

IF Date Comparison, FAILED & Qty Comparison, PASS THEN 0
IF Date Comparison, PASS & Qty Comparison, FAILED THEN 0
IF Date Comparison, PASS & Qty Comparison, PASS THEN 1

Thanks!

[Anonymous]

This should work. The 9999 is for error handling:

Outcome =

IF(

    AND('Table'[Date Comparison]="FAILED", 'Table'[Qty Comparison]="PASS"),

    0,

    IF(

        AND('Table'[Date Comparison]="PASS", 'Table'[Qty Comparison]="FAILED"),

        0,

        IF(

            AND('Table'[Date Comparison]="PASS", 'Table'[Qty Comparison]="PASS"),

            1,

            9999

        )

    )

)

[Ahmedx · Accepted solution]

pls try this

Column = IF( [Date Comparison]= "FAILED" && [Qty Comparison]= "PASS" , 0,
IF ([Date Comparison] = "PASS" && [Qty Comparison]= "FAILED",  0,
IF ([Date Comparison]= "PASS" && [Qty Comparison]= "PASS", 1)))

-----or -----
Column = SWITCH(TRUE(),
[Date Comparison]= "FAILED" && [Qty Comparison]= "PASS" , 0,
[Date Comparison] = "PASS" && [Qty Comparison]= "FAILED",  0,
[Date Comparison]= "PASS" && [Qty Comparison]= "PASS", 1)