pie chart with the legend in two columns

[Tomek1982]

Hello,

I am strugling with most probably not that difficult pie chart creation.

Basically I have 2 tables related to investment founds:

What I would like to see is a total percentage of shares and bonds. The result should be something like this:

Shares percentage in this example should be (100%*100+40%*200+80%*300)/700

As I understand as a values for a piechart I should use sum of values from the left table. My question is what to use as a legend. It may be that the right table is wrong and I should use something like the one below, but then how to create a link between those two tables.

pbix is available here: 

[isjoycewang · Accepted solution]

Hi @Tomek1982 ,

Please create a new table with column "structure" and add a column with total value as below.

I modified your demo file as attached. Let me know if any questions.

Total Value = 
SWITCH(TRUE(),
'Structure Legend'[Stucture] = "Shares", CALCULATE( SUMX('funds structure', [shares]*[Value])),
'Structure Legend'[Stucture] = "Bonds", CALCULATE( SUMX('funds structure', [bonds]*[Value])))

Best Regards,

Joyce