Forum Discussion
How to count based on another column
Hi community folks, I am building a KPI dashboard, but kind of struggling to write the correct measure. Can you please kindly help? Thanks a lot! My dataset is like this, I want to calculate ...
Hi Uzi, thanks for your reply.
DISTINCTCOUNT was my first option, however, there is a sistuation when kpi product group has more than 2, for example like the table below:
The desired outcome would be
| Opportunity Name | Credit |
| Opportunity X | 1 |
| Opportunity Y | 1 |
| Opportunity Z | 1 |
| Opportunity AA | 2 |
| TOTAL | 5 |
But if I use DISTINCTCOUNT on KPI Product Group, it will be 3 in total,
| Opportunity Name | Product Name | Stage | KPI Product Group |
| Opportunity X | Product A | Pending | A |
| Opportunity Y | Product A | Pending | A |
| Opportunity Z | Product A | Pending | A |
| Opportunity AA | Product B | Pending | B |
| Opportunity AA | Product C | Pending | C |