Writing AND function with three conditions

[bhmiller89]

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.

[KGrice · Accepted solution]

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)