Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help Needed I Group Percentage

Hello everyone, I'm a rookie on Power BI and I need help. After searching the forum and the internet I haven't found a solution. I have a graph giving me the service rate on different product categories and my goal is to group some of these categories in order to get the service rate of a group of categories. I tried to group my segment into 2 (SNACKFOOD AND GUM = MW and the rest becomes MPF) but my problem as illustrated in the attachment is that it added up the percentages (So I have 100+%) instead of creating a new one and I have no idea how to get to my goal.

So to put it simply, I'd like a percentage from percentages, not a sum of percentages on my graph.

You have the 2 graphs in copy and the groups I made in attachment

Thank you in advance for your help and if you need anything tell me 🙂

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , You can create a new measure like

     

    divide([measure], calculate([measure], filter(all(GroupTable),GroupTable[Group]  =max(GroupTable[Group] ) ) ) )