cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruesaint_denis
Frequent Visitor

Distinctcount of users per product

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. 

 

ruesaint_denis_0-1630455406722.png

 

Sample table: 

Order IDUser IDProductAge
1100Apples40
2100Oranges40
3400Apples30
4700Kiki60
5800Banana70
6600Apples50
7600Kiki50
8600Kiki50
9200Banana70

 

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

1 REPLY 1
wdx223_Daniel
Super User
Super User

wdx223_Daniel_0-1630464360807.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.