Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)
NewMeasure=DIVIDE(SUM(Table[Registered]),SUM(Table[Total Employees]),0)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
12 | |
11 | |
11 | |
8 |