How to get the unique count for each of the product details

[rajendraongole1]

Hi,

i have created a table view count, from below example 

for each of the user one product and count . but in created table there is a repeated product name and count should be come at one time for each of the username. Please suggest if any possibilities.

User Name	Product Name	Count
Testuser1	ABCD1160029675	182
Testuser2	ABCD1160029675	182
Testuser3	ABCD1160029675	182
Testuser8	ABCD1160029675	182
Testuser9	ABCD1160001007	1256
Testuser10	ABCD1160001007	1256
Testuser11	ABCD1160001007	1256
Testuser12	ABCD1160001007	1256
Testuser1	REDF160050670	98
Testuser2	REDF160050670	98
Testuser3	ABCD1160067298	1069
Testuser4	ABCD1160067298	1069
Testuser5	ABCD1160067298	1069
Testuser6	ABCD1160067298	1069
Testuser7	ABCD1160067298	1069
Testuser8	ABCD1160067298	1069
Testuser9	ABCD1160067298	1069
Testuser10	ABCD1160067298	1069
Testuser1	REDF160050670	94
Testuser2	REDF160050670	94
Testuser3	REDF160050670	94

[some_bih]

Hi @rajendraongole1 try your DAX measure : 

DistinctCountCount = CALCULATE ( DISTINCTCOUNT ( 'Sheet1'[Count] ) )

Adjust Sheet1 with your table name. I hope this help.