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 |
---|---|
81 | |
81 | |
37 | |
34 | |
31 |
User | Count |
---|---|
94 | |
80 | |
60 | |
50 | |
49 |