Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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 |
Solved! Go to Solution.
Instead of using COUNTA, use DISTINCTCOUNT or DISTINCTCOUNTNOBLANK
Instead of using COUNTA, use DISTINCTCOUNT or DISTINCTCOUNTNOBLANK
thanks it worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |