Percentage of Total between 02 columns

[Asantos2020]

Hello guys! I've got this one I can't solve!

I need to get the market share on a pie chart and be able to slice it on Date (year) basis. I have tried all kinds of DIVIDE, SUM, etc, but none of them gives me the result below (last column).

Any help is greatly appreciated!

Cheers,

Antonio Santos

[Greg_Deckler]

Have you looked at Show As, Percent of Grand Total?

[Asantos2020]

I've tried that one, as well.

If I plot it on a matrix table, it works, but not on a pie chart.

Cheers,

Antonio

[dax · Accepted solution]

Hi Asantos2020,

You need to understand that the percentage of total and your last column is different. The percentage of total is based on measure result/total of current measure(the Denominator is  the same), but the denominator of your last column(share fileld in your image) are different.

If you want to show last column's value, you could try to use below measure in pie chart(value in () is percentage of total)

Measure 4 = SUM(t3[ourexport])/SUM(t3[allexport])

Best Regards,
Zoe Zhi

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

[Asantos2020]

Thanks, @dax !

I guess I had overcomplicated it!

One reason why I may have gotten lost was because I wasn't showing Category + Value, but instead Category + Percent of Total and it then got the representation of what was on the pie chart.

Thank you!