Distinctcount of users per product

[ruesaint_denis]

Hello everyone, 

I would like to have a matrix where I show the distinct count of User ID by age and by product. This is coming from my orders table, so sometimes a user ID appears more than once, because that user bought the same product, or a new product. Please see below, the row headers would be the Products, and the column header is the Age Grouping. I did this by adding the User ID (distinct count), but I realized it's not considering that a User may have bought both X and Y products. I don't know how Power BI would be allocating that user, in which product. 

Sample table: 

Order ID	User ID	Product	Age
1	100	Apples	40
2	100	Oranges	40
3	400	Apples	30
4	700	Kiki	60
5	800	Banana	70
6	600	Apples	50
7	600	Kiki	50
8	600	Kiki	50
9	200	Banana	70

So I would want the distinctcount of USER ID to consider the product, so count USER 600 in products Kiki (ONCE), and Apples, and USER 100 in Apples and Oranges. 

Is this possible? 

Thank you, 

Denisse

[wdx223_Daniel]