Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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%

 

Need Help
Tutorial Requests

3 Replies

  • ZunzunUOC's avatar
    ZunzunUOC
    Resolver III
    7 years ago

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

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.