DAX FUNCTION FILTER

[mifrasmm]

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_ID	EQUIP_TYPE	RETURN_STATUS	REMARK1
L 10573	Van	NO	DELIVERY
m 67692	Van	NO	DELIVERY
k 77921	Van	NO	DELIVERY
l 90507	Van	YES	DELIVERY
f 88162	Truck	NO	LOADING
k 69179	Van	NO	DELIVERY
d 22581	Truck	YES	LOADING
p 21886	Van	NO	DELIVERY

[Anonymous]

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]

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 · Accepted solution]

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]

Thanks Ross for help.

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

[Anonymous]

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]

Thanks Ross, Go it