Quicksight count distinct IDs based on conditions from other column

I want to count unique IDs from one column based on values in other column. Count distinct ID if TYPE is either 'A' or 'M'.

ID	TYPE
1	A
2	M
3	A
3	M
4	M
4	M
5	A
5	A

The example above should return 1 as ID = 3 has TYPE 'A' and 'M'.

Cheers, A.