cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 (G9) to get the overall weighted value in red below (H9).

The calculations are as follows:

column G is =SUM(C2:E2)

column H is =SUM(C2:E2)/SUM(C2:F2)

cell G9 is =SUM(G2:G9)

cell H9 is =(G2*H2/G10)+(G3*H3/G10)+(G4*H4/G10)+(G5*H5/G10)+(G6*H6/G10)+(G7*H7/G10)+(G8*H8/G10)+(G9*H9/G10)

I have tried this numerous ways in Power BI but can't get it to work.  I think I need to get the value in H9 to go row by row somehow?

 A B C D E F G H 1 QueueA 48745941 4828972 1895161 6953999 55470074 0.888600685 2 QueueB 89207492 17733823 5731521 6406510 112672836 0.946199654 3 QueueC 244668 112142 23595 6369799 380405 0.056354593 4 QueueD 2996234 732404 220513 7040370 3949151 0.359356063 5 QueueE 1409574 112564 108891 6567180 1631029 0.198949429 6 QueueF 792510 186458 62615 6270647 1041583 0.14244396 7 QueueG 901662 119606 51280 2234851 1072548 0.324287454 8 QueueH 2224718 599494 210854 1793536 3035066 0.628559985 9 179252692 0.892989253

Thanks!

1 ACCEPTED SOLUTION
Microsoft Employee

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]```

Proud to be a Datanaut!

3 REPLIES 3
Microsoft Employee

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]```

Proud to be a Datanaut!

Frequent Visitor

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!

Frequent Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors