Percentage of products

[lucky9228]

Hi,

I would require help in creating the percentage of sales on differnet products in a column with one of the product in the column instead of total, column total or row total.

Thanks

[parry2k]

@lucky9228 Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[lucky9228]

So I have 3 products:
Activity exam taken         Jan  Feb  Mar   Apr  May

Maths                              253  243  256   270  277    

Physics                             150  153  156   154  123

Science                             43    35     56     54    65

So I would require an other table with percentage values based on Maths total instead of total rows or total columns.

Example:

Activity exam taken         Jan                      Feb   Mar    Apr   May

Physics                             59% (150/253)    62%  60%    57%  44%

Science                             16% (43/253)      14%  21%    20%  23%

How will I able to do this kind of percentage calculations which displacys in the same table for different months and different years going forward.

Thank you

[parry2k · Accepted solution]

@lucky9228 sample solution is attached

[lucky9228]

Thank you so much - Perfectly worked for me.