dumb DAX question

[cduval]

so I have a table and am trying to write a formula that essentially states "if these codes are are in this column, sum the values", but all three I've tried come back with (blank):

A99:=CALCULATE(SUM(dn_BillingMonthly[Corrected Billing Amt]),dn_BillingMonthly[Correct Code]="A2" && dn_BillingMonthly[Correct Code]="A3a" && dn_BillingMonthly[Correct Code]="A3b" && dn_BillingMonthly[Correct Code]="A4" && dn_BillingMonthly[Correct Code]="A5")

SUM:=CALCULATE(sum(dn_BillingMonthly[Billing_Net_EUR]),dn_BillingMonthly[Code 2]="A2" && dn_BillingMonthly[Code 2]="A3a")

SUM2:=CALCULATE(SUM(dn_BillingMonthly[Corrected Billing Amt]),FILTER(dn_BillingMonthly,dn_BillingMonthly[Correct Code]="A2"&&dn_BillingMonthly[Correct Code]="A5"))

does it matter that it's trying to find the correct codes in a calculated column?

 

[Matt Allington]

You need or, not and. The value in a column can’t be A2 and also be A5, right. It can be A2 or A5