Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 of employees in the department have provided ideas.

 

For example:

Departament have 86 employees (it's should be static number, I will enter this number by hand, because we don't have integration for this).

86 employees - 100%

56 ideas by employess - x%

Must calculate and display x value. X=65%

 

3 REPLIES 3
ZunzunUOC
Resolver III
Resolver III

Hi @Anonymous , Could you show your raw data and your expected result?

 

 

 

Anonymous
Not applicable

Hi @ZunzunUOC ,

 for example sharepoint list looks like that:

 

IDStatusDepartamentNameIdeaDescription
1CompletedFinanceJohnCreate reportText
2CompletedInformation technologyPeterAutomate reportingText
3CompletedFinanceMartinImprove the procurement processText

 

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

 

DepartmentStrength
Finance4
Information technology6

 

Table 2: Ideas

IDStatusDepartamentNameIdeaDescription
1CompletedFinanceJohnCreate reportText
2CompletedInformation technologyPeterAutomate reportingText
3CompletedFinanceMartinImprove the procurement processText

 

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.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.