Forum Discussion
Calculating Percentage
Hello, I have one question. I'm using a Sharepoint list and in Power BI I'm counting the ideas by employees of company (employees are grouped by departament). I have to calculate what percentage o...
ZunzunUOC
Resolver III
Resolver IIIHi Anonymous , Could you show your raw data and your expected result?
Hi ZunzunUOC ,
for example sharepoint list looks like that:
ID Status Departament Name Idea Description 1 Completed Finance John Create report Text 2 Completed Information technology Peter Automate reporting Text 3 Completed Finance Martin Improve the procurement process Text For example, the Finance Department has 4 people, but in the list are just 2 ideas. How to calculate:
4 employees - 100%
2 ideas - x%
X=50%. In Power BI dashboard I need to show 50%.
I wrote earlier that I will write the number of employees in the department by hand, because it is not on the list.
Assume the following are the tables in your data model.
Table 1: EmployeeStrength
Department Strength Finance 4 Information technology 6 Table 2: Ideas
ID Status Departament Name Idea Description 1 Completed Finance John Create report Text 2 Completed Information technology Peter Automate reporting Text 3 Completed Finance Martin Improve the procurement process Text Relationship: EmployeeStrength[Department] --> Ideas[Department]
RelationShip Type: One to Many
The following measures will give you the required output.
DepartmentStrength = SUMX(EmployeeStrength,EmployeeStrength[Strength])
EmployeeCountOnIDeas = COUNTROWS(Ideas)
PercentageOfEmployeesSubmittedIdea = DIVIDE([EmployeeCountOnIDeas],[DepartmentStrength],0)
Format the last measure to percentage format.