I have created a demo app and attaching the link. I want that when I select the customer ID from table1, it will show realted data in below 2nd pivot table. For this I have created a Pivot table with column name and Values. But it does not work.
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:
In Edit Queries, Duplicate the order table, and for duplicate table remove all the columns expect(Row ID, Customer ID, Product ID) like below:
Select Customer ID, Product ID then unpovit them.
Close& Apply and then create a relationship between oders and duplicate table by Row ID column
Now, drag duplicate table Attribute and Value into a table visual.
here is pbix file, please try it.
Community Support Team _ Lin If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.