how to create a Pivot table based on the selected values from another table? - Please help

hi, Anonymous 

First, you should know that calculate column and calculate table can't be affected by any slicer. 
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Second, for measure is an aggregate value, and what you want is a pivot table, you may try this way:

Step1:

In Edit Queries, Duplicate the order table, and for duplicate table remove all the columns expect(Row ID, Customer ID, Product ID) like below:

Step2:

Select Customer ID, Product ID then unpovit them.

Step3:

Close& Apply and then create a relationship between oders and duplicate table by Row ID column

Step4:

Now, drag duplicate table Attribute and Value into a table visual.

 

 

here is pbix file, please try it.

 

Best Regards,

Lin