Forum Discussion
% per group
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
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
yes, thats what I want, don't really know how to do this though
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,
Angeliav-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
Thiyags@You could drag and drop the filter(Slicer control) for group into page, then choose one option, you will understand that ALL will ignore your filter context and still apply for all values in dataset.
it was just a sample
