This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.