Percentage of sum of values in row

[shunwg]

Hi,

I have a 2D matrix, where the leftmost vertical column shows a product(towards y-direction), and each column (towards x-direction) represents a department store. A "raw" value in each cell within the table is number of a certain kind of product in each store.

I want to divide each value in the matrix, and divide it by the sum of all values in each row, instead of dividing each value by the sum of all values in each column as is done in figure below.

In this figure, I use 'Stacked Column Chart' as visualization, and I display values of '% of grand total'

[amitchandak]

@shunwg , Not clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer this : https://community.powerbi.com/t5/Desktop/Showing-percentage-values-in-Stacked-Column-Chart/td-p/1697...

https://community.powerbi.com/t5/Desktop/Percentage-of-column-total-in-a-stacked-column-chart/td-p/4...

[shunwg]

Hi again,

Thanks for your response. Was hoping to explain it without showing the raw data.

Showing again the same data, marking the row with "82,10" and shop K001, I want this cell to show the proportion K001 represents for all values in row "82,10", 

So I want the value in this cell to be % of quantity = K001(82,10) / (sum(K001(82,10),K002(82,10),K101-1(82,10),K101-2(82,10 etc) *100%. The reality is that I have more than 50 columns, so I want the same size of matrix but with percentages representing proportion of all quantities in row 82,10.

I hope this is more clarifying. 

[v-easonf-msft]

Hi, @shunwg 

K001(82,10), K002(82,10), K101-1(82,10), K101-2(82,10) etc. are   table original columns , or  measures you created ?

Best Regards,
Community Support Team _ Eason