Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have two tables—one for Sales and another that lists Donations. I'm trying to "unpack" the bundles from Sales and Donations so that I can calculate the total distributed units for each product.
Bundle 1 includes Textbook A and Textbook B.
Bundle 2 includes all three textbooks—Textbook A, Textbook B, Textbook C.
Here are my tables:
And here is what I want to produce:
@Anonymous ,
Try to add a calculated table and then use a Matrix visual to display the data.
Is there a DAX function that creates this table?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 161 | |
| 132 | |
| 117 | |
| 79 | |
| 53 |