Count total based on dimension

[pthai]

Hello guyss,

I want to count the c id colum based on the a column as below.

But the result is 4. The expected result should be 3.

Can anyone give me an idea to solve this?

Thanksss.