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 There! I am trying to get a quick sales table worked up but I can't figure out the Dax, and I'm hoping someone can help!
We have two tables related to the sale of products:
I am trying to output a matrix table (TABLE 3?) which contains values from TABLE 1 and TABLE 2 multiplied together. The overall work is pretty simple, I just cannot find anything to match the two tables together due to the duplicates in both tables.
Here's an image showing this in action:
I've color coded the rows to show how they connect to each other.
It's such a simple problem, but I cannot figure it out, can anyone help? Here's a copy of the table data in a PBI file: https://drive.google.com/file/d/172S26uzVDH79d_CEzCs5as_xZCWfo9n0/view?usp=share_link
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 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |