Forum Discussion
True/False Measure
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.
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 )
3 Replies
- Greg_Deckler
Community Champion
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 )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
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 )