I have a dataset, which is the result of a join so the ID is not a unique key:

+————+——————+——————-+—————|
| — ID — | — Name — | — Gender — | — Role — |
+————+——————+——————-+—————|
| 001 | Alex B | Male | User |
| 001 | Alex B | Male | Admin |
| 002 | John C | Male | Agent |
| 003 | Drew H | Female | User |
| 003 | Drew H | Female | Agent |
+————+——————+——————-+—————|

I know how to use count distinct with CASE to get the right numbers on Single Value charts, but I would like to find a way to build other charts counting ID just once.

For instance, if I build a Pie Chart on Gender (and Count of Gender), I will get this:
Male: 3
Female: 2

But I would like to get this instead:
Male: 2
Female: 1

How can I get this?

Thanks,
Gianfranco