Forum Discussion
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
Thank you in advance, I am grateful to you.
NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)
1 Reply
- wdx223_DanielCommunity Champion
NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)