Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all, I have two tables that are connected with a key (Product-Year-Quarter) as shown in the picture. I need help creating a measure that will show Product quantity if I use "Product" field from my main table without creating duplicated values (since my main table have multiple rows with this key).
Appretiate your help.
if I use just sum, I get 60 instead of 15
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |