Forum Discussion
Solved
COUNT ID Codes IF Columns A & B respect specific criteria
Hello there! I'm working on a table, and I need to count the number of ID Codes depending on 2 specific criteria: 1) Each ID Code has to be counted only once, while as you can see from the ID Cod...
What should your answer be in this example?
Perhaps this:
=COUNT(UNIQUE(FILTER(Table1[ID Code],Table1[Balance in $USD]<>0)))
It will return 12.
Riny_van_Eekelen sorry for the misunderstanding, actually I should have explained myself better. I just need to fill the bottom table in a dashboard, and I was trying to build a unique formula that gives me the result taking into account the parameters reported above.
| ID Code | Balance in $USD |
| 2476275379 | 35,268,847,385.00 |
| 5207551055 | 205,721,030.00 |
| 9359515808 | 91,720,392,066.00 |
| 2476275379 | 38,491,785,509.00 |
| 3967032414 | 42,833,118,004.00 |
| 8663489462 | 0.00 |
| 4931997212 | 67,749,503,521.00 |
| 2951917685 | 23,981,235,402.00 |
| 2830183998 | 64,626,847,523.00 |
| 1005553923 | 94,602,840,726.00 |
| 2374653231 | 0.00 |
| 7478040492 | 88,095,379,658.00 |
| 1005553923 | 28,086,717,554.00 |
| 9488876464 | 78,954,674,545.00 |
| 7980868034 | 81,063,980,379.00 |
| 8428446508 | 48,394,944,086.00 |
| SUMMARY TABLE |
| Total number of ID Codes |
| ? |
What should your answer be in this example?
Perhaps this:
=COUNT(UNIQUE(FILTER(Table1[ID Code],Table1[Balance in $USD]<>0)))
It will return 12.