Slicers on source table to reflect values on aggregated table

[FrailHumanity]

Hi,

I have a source table 

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6
A	1	R	3	C	5
B	3	V	5	C	7
C	3	R	6	D	4

I have an aggregated table created using the table above which looks like this

Column 5	Sum - Column 6
C	12
D	4

I want to filter on source table and aggregate it on the second table.

Could you please let me know how I can achieve this?

[v-yangliu-msft · Accepted solution]

Hi  @FrailHumanity ,

Here are the steps you can follow：

1. Copy the source table to Flag table – Transform -- select [Column1], [Column3], [Column5] -- Unpivot Columns.

Result:

2. Transform – select [Column2] , [Column4] , [Column6] --  Unpivot Columns ..

Result:

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly