Too few arguments were passed to the AND function

[Anonymous]

Hello,

I am having trouble with this formula. I need to make a measure which should answer these 2 different conditions in Power BI,

but I see this error. 

Can you help me to understand ?

Aggressive/Non Aggressive2 = IF(SUM(Sheet1[LTREQ])>SUM(PMD[Total LT]),AND(IF(SUM(Sheet1[Quantity])>SUM(PMD[Maximum order quantity]),"Aggressive")))

Thank you in advance.

Baris 

[Syk]

It looks like you're trying to do a nested if statement. You CAN do that and I think all you would need to do is delete your AND function. Then your if statement would read:
if condition 1 is true then if condition 2 is true then "Aggressive" else blank

You should also be able to use 1 if statement and rewrite this as

Aggressive/Non Aggressive2 =
IF (
    SUM ( Sheet1[LTREQ] ) > SUM ( PMD[Total LT] )
        && ( SUM ( Sheet1[Quantity] ) > SUM ( PMD[Maximum order quantity] ) ),
    "Aggressive"
)

Using && as your AND

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Aggressive/Non Aggressive2 = 
  IF(
    AND( 
      SUM(Sheet1[LTREQ])>SUM(PMD[Total LT]),
      SUM(Sheet1[Quantity])>SUM(PMD[Maximum order quantity])
    ),
    "Aggressive", 
    "Non Aggressive"
  )

or:

Aggressive/Non Aggressive2 = 
  IF(
      SUM(Sheet1[LTREQ])>SUM(PMD[Total LT]) 
      && 
      SUM(Sheet1[Quantity])>SUM(PMD[Maximum order quantity]),
    "Aggressive", 
    "Non Aggressive"
  )