Quicksight count distinct IDs based on conditions from other column
04:15 23 May 2021

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

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

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

Cheers, A.

if-statement count distinct calculated-field amazon-quicksight