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

Thiyags's avatar
Thiyags
Helper II
9 years ago

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

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

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.