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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

View solution in original post

1 REPLY 1
wdx223_Daniel
Super User
Super User

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors