Distinct Count based on multiple column

Hi,

I have data like this

Id Name Value1 Value2

1 abc      1          1

2 abc      1          2

3 abc      1          3

4 pqr      2         1

5 pqr      2         2

6 abc      1          1

7 abc      1          2

8 mnq    3          1

9 pqr      2         1

10 xyz    4         2

Now my calculation is like this

var a = DISTINCTCOUNT(value1)

var b = COUNT(Value2)

My result wold give me like

abc 1 - 5

pqr  1 - 3

mnq 1 - 1

xyz   1 - 1

But I need

abc 1 - 3

pqr  1 - 2

mnq 1 - 1

xyz   1 - 1

For this I need to count distinct on multiple column so

1 abc      1          1

6 abc      1          1

this will result only 1

Thanks And Regards

Krunal Patel