Row wise percent of total

[Anonymous]

Dear Community !

Need your help to calculate row-wise totals as shown below:

(There are 232 Client Names in Category 1, etc, which mean Client_Sum itself is a calculated field.

Thanks in advance !

[FreemanZ · Accepted solution]

hi @Anonymous 

Supposing you have a table with two columns: Category and Value,

try to plot a table visual with the Category column and two measures like:

Client_Sum =
SUM(TableName[Value])

Client_Perc =
DIVIDE(
SUM(TableName[Value]),
CALCULATE(SUM(TableName[Value]), ALL(TableName))
)

[djurecic]

Hi @Anonymous ,

 Take a look at this thread:

https://community.powerbi.com/t5/Desktop/Percentage-of-Total-in-Matrix/td-p/1850106

[Anonymous]

Hello !

Thanks for your response, infact I did look at this very post before posting my question. This is very close to what I need, howeve, my apologies, I am just a novice and couldn't figure out &/or manipulate the suggested steps to my requirement.

If you could please 'tune' it to mine, I will be really thankful.