Need help - Multiplying sum of one column by the value in another

[Anonymous]

I am trying to take the sum of a numeric column and multiply it by a hard coded rate value in one field of another column. I would then "copy" this all the way down the table. Simple to do in XL, I cannot figure it out in PBI.

[Nathaniel_C]

Hi @Anonymous 

MY PBIX 

Took the sum of the column * percentage * each row. Percentage is a measure for ease of use, can change at any time. Just make sure the column is set to don't summarize.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous · Accepted solution]

Thank you for all of the support. I figured it out, at least in a way. I just removed the filters form the viz and used DAX Calculate Fx to create new Rows/Measures of the filtered data I needed. This allowed me to create a hard values column of the subtotal that I then multiplied by the factor. Thanks again - take care!

[Nathaniel_C]

@Anonymous ,

You are welcome!

[nilimarodrigues]

Is this what you are looking for? If yes, in data view, you can create a new column with given formula.

[Nathaniel_C]

Hi @Anonymous ,

Go to Power Query, go to Add Column, select the column you wish to multiply, click on the multiply.  Fill in the value, and it will create a column.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

@Nathaniel_C  thank you for your response.

I think I did not explain my issue completely. What i have is a total of some amount in a table viz that has a couple of filters applied. I am trying to multiply the total of those amounts as displayed in the viz by a factor (percentage) in a separate column. I would then want to display that new amount in it's own column within the same table. I am open to displaying in a separate table/viz as well.

In XL, to would look like =SUM($A$87*B1) all the way down however many rows (where cell A87 is Total of Amount).

[nilimarodrigues]

Would you mind attaching a sample done in excel just to get a bit clear understanding.