How to Create a weighted Average Instead of Averaging Percentages in a Matrix?

[Wearin]

Sorry if that subject is confusing, but I will explain it in detail here.

I have a matrix that has Jobs and People as rows. I then have 3 columns, the amount of money someone had previously, the amount they have now, and a column that is New amount / Old Amount to get the Percent changed. I am Summarizing the Percent Changed as an Average.

What I want to happen here is for it to be a weighted average here instead of what is happening. I want the totals to reflect overal percentage change per category. 

So for example, instead of  Dev's average being 3.583 from the averaging of 7, 1.25, and 2.5, I want it to be 1757/1201= 1.46 to get an actualy representation of the overall change.

I know I can do this with a measure for the sum of those two columns, but I am trying to find a way to accomplish this without adding extra columns or making a seperate visual, because the ability to neatly get all that information per category is extremely useful.

Is there a way to accomplish this?

[mahoneypat · Accepted solution]

Can you just change your Average of % Change measure to this?

DIVIDE([NewAmount], [PreviousAmount])

That should get the same values for each person and your desired result at the job level.

Pat

[Wearin]

Hello Pat,

I'm an idiot. Thank you!

Since Measure requires doing some form of measure for the data (in this example Sum) I assumed I couldn't do it in this specific scenario without it summing ALL values, but that was exactly what I needed.