How to Divide byone table column divide by column total and multiply with another table

[Manigandan]

I am trying to create some measures in power bi, where I want to divide each score by the sum and multiplay with another corrected sum amount  for each group

Table 1                                                                                                          

Corrected in excel formula is :=ROUND(C86/$C$98*$C$100,0) in B105 column formula in output table

My Output is

I need the above output Please share me anyone know that

[govindarajan_d · Accepted solution]

Hi @Manigandan,

Can you please try this:

CorrectedSum = 
VAR __AllSumDivide = CALCULATE(SUM(Table[FirstColumn]),ALL(Table))
VAR __AllSumMultiply = CALCULATE(SUM(Table[SecondColumn]),ALL(Table))

RETURN SUMX(Table,DIVIDE(Table[CColumn],__AllSumDivide)*__AllSumMultiply)

[v-yanimei-msft · Accepted solution]

Hi @Manigandan ,

Please follow these steps:

1. Right-click Table , select New column  and input them with texts as pictures shown.

Best Regards

Caroline Mei

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[govindarajan_d · Accepted solution]

Hi @Manigandan,

Can you please try this:

CorrectedSum = 
VAR __AllSumDivide = CALCULATE(SUM(Table[FirstColumn]),ALL(Table))
VAR __AllSumMultiply = CALCULATE(SUM(Table[SecondColumn]),ALL(Table))

RETURN SUMX(Table,DIVIDE(Table[CColumn],__AllSumDivide)*__AllSumMultiply)