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