Filter records that have value X but not Y

[RsRoel]

I've been breaking my head about the following: I'd like to filter ID's that have certain values but not others. E.g.

ID	Value
1	A
1	B
1	C
2	A
2	C
2	D
3	C
3	D
3	E

What I would like to happen here is filter the ID's that have A, but do not have B. So In the end you have the output: 

ID	Value
2	A
2	C
2	D

 As ID 1 has A and also B, and ID 3 does not have B, but also not A. 

Anyone an idea how to solve this? 

[parry2k · Accepted solution]

@RsRoel create a measure for condition and then use it in visual level filter or add it in the table visual

Filter = 
VAR __val = CALCULATETABLE ( VALUES ( 'Table'[Value] ),  ALLEXCEPT ( 'Table', 'Table'[ID] ) )
RETURN
IF ( "A" IN __val && NOT "B" IN __val, "Y" )

[parry2k]

@RsRoel use it as a filter