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 |
