The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
User | Count |
---|---|
82 | |
82 | |
35 | |
32 | |
32 |
User | Count |
---|---|
93 | |
79 | |
62 | |
54 | |
51 |