Forum Discussion

Varela's avatar
Varela
Frequent Visitor
9 years ago
Solved

% per group

I have Agents that belongs to a group, like the sample data below, what I like to do is the % not being of every agent of every group but be % relative to its group.   Agent                        ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Varela，

    How do you get the sample % data, based on your description, the percentage of Jessica Brito should be 35/(26+35+21+25)=32% rather than 7.99% given. Or you post part of your data?

    First, please create a measure to calculate the total sum of each group. Then create a calculate column to get what you want.

    Total group = CALCULATE(SUM(Table15[Tickets closed]),ALLEXCEPT(Table15,Table15[Group]))
    Percentage = Table15[Tickets closed]/Table15[Total group]

     



    If you have any question, please feel free to ask.


    Best Regards,
    Angelia

Thiyags's avatar
Thiyags
Helper II
9 years ago

I dont understand ur question.

 

You want the % to displayed for every agent out of his/her group.

 

Eg . Jessica Brito belong to group 2

Formula = Tickets closed by Jessica / Total Tickets closed in Group 2

 

 

  • Varela's avatar
    Varela
    Frequent Visitor
    9 years ago

    yes, thats what I want, don't really know how to do this though

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Varela，

      How do you get the sample % data, based on your description, the percentage of Jessica Brito should be 35/(26+35+21+25)=32% rather than 7.99% given. Or you post part of your data?

      First, please create a measure to calculate the total sum of each group. Then create a calculate column to get what you want.

      Total group = CALCULATE(SUM(Table15[Tickets closed]),ALLEXCEPT(Table15,Table15[Group]))
      Percentage = Table15[Tickets closed]/Table15[Total group]

       



      If you have any question, please feel free to ask.


      Best Regards,
      Angelia

      • Thiyags's avatar
        Thiyags
        Helper II
        9 years ago

        v-huizhn-msft Thanks. This works. can you explain when to use ALL and when to use ALLEXCEPT

         

        Varela Can u try the formula which Angelia suggested