filter the duplicates of a column to have a total number per category without duplicates

[Jeffreyjar]

Hello Everyone,

Please i need help,

I want to have the number of agents(New Agents Codes) by category(CODE AGENCE)  but when I execute the formula it also counts duplicates , I used this formula but it does not give the result I expect  

Total de Nombre de New Agents Codes pour CODE AGENCE =

CALCULATE(

    COUNTA('APE 03 2022'[New Agents Codes]),

    ALLSELECTED('AM (2)'[CODE AGENCE])

)

it is giving me this result with duplicates

Total de Nombre de Agent Name pour Manager
319
99
217
146
173
153
53
63
76
65
49
220
93
49
54
47
39
155
176
123
226
58
75
40

the New Agents Codes column

New Agents Codes

A19911001

A10599013

A19999030

A19999009

A19906001

A19903001

A19903001

A10599013

A10299008

[johnt75 · Accepted solution]

Instead of using COUNTA, use DISTINCTCOUNT or DISTINCTCOUNTNOBLANK

[Jeffreyjar]

thanks it worked