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 help

 

EQUIP_IDEQUIP_TYPERETURN_STATUSREMARK1
L 10573VanNODELIVERY
m 67692VanNODELIVERY
k 77921VanNODELIVERY
l 90507VanYESDELIVERY
f 88162TruckNOLOADING
k 69179VanNODELIVERY
d 22581TruckYESLOADING
p 21886VanNODELIVERY
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"
)

6 Replies

  • 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"
)