True/False Measure

[Anonymous]

Hello, 

I am trying to create a true/false measure based on a numeric field and a text field.

If Number of Units is 1 and type of find is Packaging show 1, if not show 0 etc...

This is where I am at so far, but the syntax is incorrect

EP1 = IF(AND(SUM('Data'[Number of Units]=1),'Data'[Type of Find]="Packaging"),1,0)

EP2 = IF(AND(SUM('Data'[Number of Units]=2),'Data'[Type of Find]="Packaging"),1,0)

EP3 = IF(AND(SUM('Data'[Number of Units]>2),'Data'[Type of Find]="Packaging"),1,0)

WL1 = IF(AND(SUM('Data'[Number of Units]=1),'Data'[Type of Find]="Location"),1,0)

WL2 = IF(AND(SUM('Data'[Number of Units]=2),'Data'[Type of Find]="Location"),1,0)

WL3 = IF(AND(SUM('Data'[Number of Units]>2),'Data'[Type of Find]="Location"),1,0)

I will use the measures in states on a visual to gradient colour based on value, with different colours for Packaging and Location.

Hope that makes sense, any help would be really apprechiated.

[Greg_Deckler]

@Anonymous Seems like this should be:

EP1 =
  IF(
    AND(
      SUM('Data'[Number of Units]=1),
      MAX('Data'[Type of Find])="Packaging"
    )
    ,1,0
  )

or

EP1 = 
  IF(
    SUM('Data'[Number of Units]=1) &&
    MAX('Data'[Type of Find]="Packaging")
    ,1,0
  )

[Anonymous]

@Greg_Deckler 

Thanks for reply, unfortunatley the error: The SUM function only accepts a column reference as an argument. has come up with both options. 

'Data'[Number of Units] is a numeric field, 

'Data'[Type of Find]="Packaging" is a text field.

[Greg_Deckler · Accepted solution]

@Anonymous - Try:

EP1 =
  IF(
    AND(
      SUM('Data'[Number of Units])=1,
      MAX('Data'[Type of Find])="Packaging"
    )
    ,1,0
  )

or

EP1 = 
  IF(
    SUM('Data'[Number of Units])=1 &&
    MAX('Data'[Type of Find])="Packaging"
    ,1,0
  )