cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FrailHumanity
Frequent Visitor

Slicers on source table to reflect values on aggregated table

Hi,

 

I have a source table 

 

Column 1Column 2Column 3Column 4 Column 5Column 6
A1R3C5
B3V5C7
C3R6D4

 

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

 

Column 5Sum - Column 6
C12
D4

 

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?

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @FrailHumanity ,

 

Here are the steps you can follow:

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

vyangliumsft_0-1680682844480.png

Result:

vyangliumsft_1-1680682738874.png

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

vyangliumsft_2-1680682738876.png

Result:

vyangliumsft_1-1680682900737.png

 

3. Result:

vyangliumsft_2-1680682907838.png

 

 

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

View solution in original post

1 REPLY 1
v-yangliu-msft
Community Support
Community Support

Hi  @FrailHumanity ,

 

Here are the steps you can follow:

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

vyangliumsft_0-1680682844480.png

Result:

vyangliumsft_1-1680682738874.png

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

vyangliumsft_2-1680682738876.png

Result:

vyangliumsft_1-1680682900737.png

 

3. Result:

vyangliumsft_2-1680682907838.png

 

 

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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors