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 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"
)
mifrasmm's avatar
mifrasmm
Helper I
9 years ago

Thanks Ross for help.

OR fucntion can create max 2 arguments , if i want add one more is there any  option

  • 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