Need A Help with DAX Formula

[Anonymous]

Hello,

Can you please help me writing  DAX formula. I want to calculate the total products consumed by a customer. Can you please help me to write the formula? Really appreciate your time and efforts.

Customer ID	Product	Total Product Purchase by Customer
1	A
1	B	2
2	A	1
3	A	1
4	B	1
5	B
5	B	2

[Fowmy]

@Anonymous 

Create  the following measure  by right-clicking on the table, and choosing New Measures:

Total Products = COUNT(Table[Product])

Then, add the Customer ID and the measure to a Table Visual.