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

Hi Ross,

 

Thanks for replying , its working

 if i want include "LOADING " as well, I tried 

 

Available = CALCULATE(COUNTA(EquipLive[EQUIP_ID]),'EquipLive'[REMARK1]="DELIVERY",'EquipLive'[REMARK1]="LOADING", 'EquipLive'[RETURN_STATUS]="NO")

 

Giving no result , Please help

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