Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |