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...
Hi 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.