Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
je7golf
New Member

Matrix Row % of the Total

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%

 

je7golf_0-1718849732406.png

 

Thank you,

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vxingshenmsft_2-1718935139356.png

 

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.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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.

vxingshenmsft_2-1718935139356.png

 

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
Super User
Super User

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

 

rajendraongole1_2-1718856512768.png

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!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hello, this is the error I keep getting.

je7golf_0-1718923224024.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.