Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculating Total Distributions

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:

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous ,

     

    Try to add a calculated table and then use a Matrix visual to display the data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Is there a DAX function that creates this table?