Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
10 years ago
Solved

Writing AND function with three conditions

IsReferral= IF(AND(SalesLeads[IsWebLead]=0, SalesLeads[IsPhoneLead]=0....

 

But I also need to say "and if SalesLeads[IsSelfGen]=0"

 

If all three conditions are met, then 1, else 0.

 

I'm assuming I need to connect it using && somehow.

Need Help
  • KGrice's avatar
    KGrice
    10 years ago

    For some reason, the DAX version of AND only accepts two arguments, but you're correct about using &&. Just use that between each condition, which you can separate with parentheses for easier reading if you prefer.

     

    IsReferral = IF(SalesLeads[IsWebLead]=0 
    	&& SalesLeade[IsPhoneLead=0 
    	&& SalesLeads[IsSelfGen]=0, true result, false result)

     

     

    You could also nest two AND functions, but that's ugly by comparison:

     

    IsReferral = IF(AND(
    	AND(
    		SalesLeads[IsWebLead]=0, 
    		SalesLeade[IsPhoneLead=0
    	), SalesLeads[IsSelfGen]=0
    ), true result, false result)

     

     

     

     

     

1 Reply

  • KGrice's avatar
    KGrice
    Memorable Member
    10 years ago

    For some reason, the DAX version of AND only accepts two arguments, but you're correct about using &&. Just use that between each condition, which you can separate with parentheses for easier reading if you prefer.

     

    IsReferral = IF(SalesLeads[IsWebLead]=0 
    	&& SalesLeade[IsPhoneLead=0 
    	&& SalesLeads[IsSelfGen]=0, true result, false result)

     

     

    You could also nest two AND functions, but that's ugly by comparison:

     

    IsReferral = IF(AND(
    	AND(
    		SalesLeads[IsWebLead]=0, 
    		SalesLeade[IsPhoneLead=0
    	), SalesLeads[IsSelfGen]=0
    ), true result, false result)