Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 Group Tickets closed %
Analista | Grupo | Tickets Fechados | %GT Tickets Fechados |
Jessica Brito | 02 - Vendas | 26 | 5.94% |
Jonatas Cruz | 02 - Vendas | 35 | 7.99% |
Rafael Ferreira | 02 - Vendas | 21 | 4.79% |
Vanderlei Gabriel de Souza | 02 - Vendas | 25 | 5.71% |
Heliberta Siqueira | 03 - Store Manager | 17 | 3.88% |
Luciano Pereira | 03 - Store Manager | 1 | 0.23% |
Stephany Marques | 03 - Store Manager | 33 | 7.53% |
Caio Augusto Silva Santos | 04 - E-commerce | 14 | 3.20% |
Rafael Cavalcante | 04 - E-commerce | 3 | 0.68% |
Rafael Garcia | 04 - E-commerce | 8 | 1.83% |
Solved! Go to Solution.
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,
Angelia
it was just a sample
@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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |