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

Here is what i'd write.  This is off the top of my head so you might need to put it into your Power BI and get it to check for errors:

Equip Count = Calculate(
	counta('TableName'[EQUIP_ID}),
	'TableName'[RETURN_STATUS] = "NO",
	'TableName'[REMARK1] = "DELIVERY"
)

Where 'TableName' is the name of the table that you are using

EDIT:  I should note this is intended as a measure.

 

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