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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Creating a Percentage column - Beginner

In my company table, I have a column of employees, a column of registered employees and I am trying to make a 3rd column to show the percentage of employees who have registered. I have tried a new measure, a quick measure, i just can not figure this out and it seems like it should be so easy. I even tried to create the column in excel and then just plop it into

 

I need to be able to show on a dashboard or report(I am using a card right now, 3 cards, 1 for # of employees, 1 for # of registered and the third will be for percentage of employees who have registered). I have a slicer because I need to report these numbers by company.

My Employer Table

jodyfox61_0-1678153621570.png

Thank you in advance, I am grateful to you.

1 ACCEPTED SOLUTION
wdx223_Daniel
Community Champion
Community Champion

NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)

View solution in original post

1 REPLY 1
wdx223_Daniel
Community Champion
Community Champion

NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.