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

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

Varela's avatar
Varela
Frequent Visitor
9 years ago

it was just a sample