Row Percent of Row Total Percent

[Anonymous]

Hello, 

I am creating a matrix and I want the percentage of the row total. Instead of it being out of 100%, I just want to get the proportion of the total row percentage. 

Example:

                  Jan        Feb       Mar         Total

January      6%         7%        6%            19%   

Febuary     4%         3%        2%             9%

March        6%         9%        1%            16%

Thanks for your help if you can

[Anonymous]

Go to Values, right mouse and then Show value as.... percent of row total

[Anonymous · Accepted solution]

Hi JaneElliott,

I've made an example with dummydate on how you could solve this.

Dummy DataResult

I've divided the value with the total value.

The Total value is calculated by the following measure:

Total = SUMX(ALL(Table1);Table1[Value])

I then used the following measure to calculate row percentage:

Percent of Total = SUM(Table1[Value])/[Total]

Hope this will help.

Kind Regards,

[Anonymous]

Thank you, that's exactly what I needed.

[Stachu]

can you share sample data and syntax for the measures you're using? you can follow the advice here
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490