Forum Discussion
Solved
How do I sum percentages correctly?
Hi, I have got a request from the business that I support to recreate the following in Power BI. They are assigning a weight to each row (column G). They then use the sum of the overall weight (...
Hi banteerlass
I create the following three calculated columns
G1 = 'Table1'[C] + 'Table1'[D] + 'Table1'[E] G9 = CALCULATE(SUM('Table1'[G1]),ALL('Table1')) H1 = DIVIDE('Table1'[G1] , ('Table1'[G1] + 'Table1'[F])) H9 = 'Table1'[G1] * 'Table1'[H1] / 'Table1'[G9]
Hi banteerlass
I create the following three calculated columns
G1 = 'Table1'[C] + 'Table1'[D] + 'Table1'[E]
G9 = CALCULATE(SUM('Table1'[G1]),ALL('Table1'))
H1 = DIVIDE('Table1'[G1] , ('Table1'[G1] + 'Table1'[F]))
H9 = 'Table1'[G1] * 'Table1'[H1] / 'Table1'[G9]
Hi Phil_Seamark,
Thank you so much for this!! I'll try it and let you know how it goes. The actual dataset I'm working with is different from the Excel sheet I got from the business though. Each queue has many rows associated with it. So I just need to play with your approach a bit to get it to work. I'll let you know how it goes. Thanks again!
How would I do this if there are multiple rows per queue? Do I need to use CALCULATE? The example I gave had the summed up numbers per queue. I've tried your approach but I feel there is something up with my grouping.
