Calculated Column - IF client activity contains X then Y

[Anonymous]

Hi guys, 

This will likely be a very simple answer but I'm hitting a wall for some reason. 

Essentially, If the client ID has a certin activity against it, I need a True or false/1 or 0 next to the entire client record. For exmple, see the table below. 

Activites

client ID	activity
1	a
1	b
1	c
2	a
2	a
2	a
3	a
3	b
3	b
4	c
4	c
4	c

I need to add a colum that identifies all clients who had NOT had activity C. 

result 

Clinet ID	activity	new
1	a	0
1	b	0
1	c	0
2	a	1
2	a	1
2	a	1
3	a	1
3	b	1
3	b	1
4	c	0
4	c	0
4	c	0

As client 1 and 4 have both had Activity C, all their records needs to be False or 0. 

Ideally, this needs to be completed in DAX. 

Thanks in Advanced. 

Edit/note
Client ID on my actual table is Alphanumeric. 

[AntrikshSharma · Accepted solution]

@Anonymous For a measure try this:

For a calculated column try this:

PBI file is attached below my signature.