Forum Discussion
Weighted Average Measure
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% |
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.
2 Replies
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.
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.
