Forum Discussion

banteerlass's avatar
banteerlass
Frequent Visitor
9 years ago
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 (...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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]