Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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.

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

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