IF(CountIFS Greater than + other criteria

[moeconsult]

Please see below my excel formula which is returning the right result 

Excel Formula =IF(COUNTIFS(A:A,A2,B:B,"cs-ac",C:C,"Passed")>0,"Passed","No")

I have tried the dax formulas below but not returning what I expect, any help to perfect Dax would be great .

Status = IF(COUNT(Data[value])>0,IF(AND(Data[type]="cs-ac",Data[state]="Passed"),"Passed","No"))

Status = Var P = COUNT(Data[value])

Return

SWITCH(

TRUE(),

P >0,IF(AND([sic_type]="cs-ac",[state]="Passed"),"Passed","No"))

Sample data and output

A               B                   C                          D

value	Type	State	Output
01ed570e	under	complete	No
01ed570e	progr	complete	No
01ed570e	under	complete	No
01ed570e	data-	complete	No
01ed570e	an-in	complete	No
01ed570e	regis	complete	No
01ed570e	netwo	complete	No
01ed570e	cs-ac	complete	No
01ed570e	algor	complete	No
01ed570e	cs-ac	complete	No
01ed570e	repre	in_progress	No
0423565b	progr	complete	Passed
0423565b	under	complete	Passed
0423565b	regis	complete	Passed
0423565b	netwo	complete	Passed
0423565b	cs-ac	complete	Passed
0423565b	pytho	complete	Passed
0423565b	algor	complete	Passed
0423565b	cs-ac	complete	Passed
0423565b	progr	enrolled	Passed
0423565b	netwo	enrolled	Passed
0423565b	progr	enrolled	Passed
0423565b	repre	enrolled	Passed
0423565b	teach	enrolled	Passed
0423565b	how-c	enrolled	Passed
0423565b	intro	enrolled	Passed
0423565b	intro	enrolled	Passed
0423565b	desig	enrolled	Passed
0423565b	objec	enrolled	Passed
0423565b	under	enrolled	Passed
0423565b	data-	dropped	Passed
0423565b	progr	in_progress	Passed
0423565b	intro	in_progress	Passed
0423565b	ncce-	dropped	Passed
0423565b	gcse-	dropped	Passed
0423565b	impac	in_progress	Passed
0423565b	cs-ac	passed	Passed

@Greg_Deckler @Ashish_Mathur 

PM