Calculated Column Based On Member Presence In Group

[AC_DATA]

I need help creating a calculated column that indicates whether a certain member is in a group or not (see below):

GROUP	MEMBER_TYPE	COUNT	ORANGE_PRESENT
1	Apple	13	1
1	Orange	3	1
1	Cherry	5	1
1	Grape	11	1
2	Cherry	7	0
2	Banana	4	0
2	Apple	8	0
3	Grape	1	1
3	Apple	4	1
3	Orange	16	1
3	Banana	9	1
3	Cherry	1	1

Only Group 1 and Group 3 contain the member "Orange" so the calculated column "ORANGE_PRESENT" should contain the value 1 for all corresponding rows in those groups and Group 2 which does not contain the member "Orange" should have the corresponding values of 0.

Can anyone provide me with some direction on writing the DAX code to accomplish this?

[AnthonyTilley · Accepted solution]

Try this 

Column =

Var Val = "ORANGE"

Var Grp = Table1[GROUP]

var check = CALCULATE(COUNT(Table1[GROUP]),Table1[GROUP]=Grp,filter(ALL(Table1),Table1[MEMBER_TYPE]=Val))

var ret = if(check=blank(),0,check)

return ret

[mussaenda]

You may want to check this thread.