topic Re: How to Divide byone table column divide by column total and multiply with another table in DAX Commands and Tips

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

Manigandan — Sun, 25 Feb 2024 11:52:34 GMT

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

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

govindarajan_d — Sun, 25 Feb 2024 15:29:03 GMT

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)

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

v-yanimei-msft — Mon, 26 Feb 2024 10:00:40 GMT

Hi Manigandan ,

Please follow these steps:

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.