Weighted Average Measure

[buttercream]

How do I create a measure that will calculate the weight of an amount relative to a category or multiple categories?

 Example below I'd like a measure to calculate the weight of each payment = payment/sum of payments but have one measure for the two columns below.

Customer	Payment	Weighted Payments by Customer	Weighted Payments Total
Jim	$1,000	13.89%	11.76%
Jim	$1,200	16.67%	14.12%
Jim	$5,000	69.44%	58.82%
Bob	$500	38.46%	5.88%
Bob	$800	61.54%	9.41%

[Ashish_Mathur]

Hi,

There has to be at least one additional column in the visual to avoid aggregation at the Customer level.  Once you drag that column as well, you can either write measures or use visual calculations.  To receive specific help, share that additional column as well.

[MFelix · Accepted solution]

Hi @buttercream ,

I assume that you have additional information for this visualization in this case I added an ID column just to get the correct syntax add the following two measures:

Weighted Payments Total = DIVIDE(SUM('Table'[Payment]), CALCULATE(SUM('Table'[Payment]), REMOVEFILTERS('Table'[Customer],'Table'[ID])))

Weighted Payments by Customer = DIVIDE(SUM('Table'[Payment]), CALCULATE(SUM('Table'[Payment]), REMOVEFILTERS('Table'[ID])))

Be aware that you may need to change this accordingly to your model and visualization.