Need help with DAX

[gauravnarchal]

Dear All -  I need your help in achieving the below requirement:-

Sample Data PBIX

Requirement

If the Invoice number starts with “9”

ð NI Receipts (Authentication Response) is “SUCCESS” & NI Receipts (Order Status) is “CLOSE”

Then Match

ð Receipts (Auth Code) = NI Receipts (Capture Code) & Receipts (Cash Amount) = NI Receipts (Refund Amount)

Return “PASS” else “FAIL”

If the Invoice number starts other than “9”

ð NI Receipts (Authentication Response) is “SUCCESS” & NI Receipts (Order Status) is “CLOSE”

Then Match

ð Receipts (Auth Code) = NI Receipts (Capture Code) & Receipts (Cash Amount) = NI Receipts (Capture Amount)

Return “PASS” else “FAIL”

[lbendlin]

Your data model is not suitable.  M:M relationships with bidirectional search will create ambiguities.

Correct your data model.