Forum Discussion

mifrasmm's avatar
mifrasmm
Helper I
9 years ago
Solved

DAX FUNCTION FILTER

HI,   i m having a table with below values, I need a count the equip id  row 's using filter Return_status ='NO' & REMARK1='DELIVERY'  & result value need - with consent value 100  Please can u he...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    You were sooo close.  All you need to do is make use of the OR function.  So the code would read:

     

    Available = CALCULATE(
        COUNTA(EquipLive[EQUIP_ID]),
	OR(
		'EquipLive'[REMARK1]="DELIVERY",
		'EquipLive'[REMARK1]="LOADING"
	),
	'EquipLive'[RETURN_STATUS]="NO"
)
Anonymous's avatar
Anonymous
Not applicable
9 years ago

You are able to nest OR within OR.  If you remember doing Algrabra at school, it works like that where you resolve the innerparts of the equation and work outwards.  So lets say you had 8 things to OR, you could have a statement like:
OR(OR(OR(OR(OR(OR(OR(1,2),3),4),5),6),7),8)

it would resolve like:
Does 7 = OR(OR(OR(OR(OR(OR(OR(1,2),3),4),5),6),7),8)
OR(OR(OR(OR(OR(OR(FALSE,3),4),5),6),7),8)
OR(OR(OR(OR(OR(FALSE,4),5),6),7),8)
OR(OR(OR(OR(FALSE,5),6),7),8)
OR(OR(OR(FALSE,6),7),8)
OR(OR(FALSE),7),8)
OR(TRUE,8)
TRUE

mifrasmm's avatar
mifrasmm
Helper I
9 years ago

Thanks Ross, Go it