Forum Discussion
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 ...
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
