Getting Percentage per Row Using Column Total

[markefrody]

Hi,

I am trying to get the percentage for each row using the "Total" column total value. Below is an example of the result I am trying to replicate in Power BI (highlighted in gray). 

Note: The data I am using is derived from Direct Query.

 

Kindly click on the below to see the PBI file that I am working with.

PBI file  

Appreciate if you can help me. Thanks!

Best regards,
Mark 

[Ashish_Mathur · Accepted solution]

Hi,

In PowerBi desktop, you cannot get a % column only for the Total column.  The % column will appear for the other columns as well.  However, what you want can be achieved in MS Excel.