Matrix Row % of the Total

[je7golf]

Hello,

I am new to Power BI I am trying to do what I thought would be simple and am struggling. I would like to add an additonal column and calculate the % of On Time for the row.

For Example:

Employee % On Time = 70%

National % On Time = 76.4%

Thank you,

[v-xingshen-msft · Accepted solution]

Hi @je7golf ,

Thank you  @rajendraongole1  very much for the solution,

Regarding the problem you encountered later, I think it might be your use of brackets that is causing, some problems, and you can modify it according to the scenario I gave you.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Hi @je7golf - Create a below measure to find the % percentage 

Measure:

% On Time1 = DIVIDE(SUM(Matrix[On Time]), SUM(Matrix[On Time]) + SUM(Matrix[Late]), 0) 

above % measure, place it at values

Total = SUMX(Matrix,Matrix[On Time] + Matrix[Late])

it works please check.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[je7golf]

Hello, this is the error I keep getting.