Forum Discussion
Calculating Weighted Average
Hi Catman ,
Thank you for sharing the update!
It might happening because the total amount by customer is being calculated at the invoice level instead of staying fixed for the customer. This happens when the visual includes invoice-level detail, and the measure does not ignore that context. To get the right weight % and average payment days, the total amount should remain the same across all invoices for a customer. Also, since your Customer and Invoice tables are separate, just make sure there is a proper relationship between them.
Hope this helps.
Thank you.
Hi, I have tried using the excel file from both solution to calculate the weight % but I keep having the same problem with the Total Amount by Customer. It just shows the individual Amount when I added the InvoiceID instead of aggregating the total.
So this is what I keep getting as a result:
| Customer | Invoice | Amount | Total Amount by Customer | Paymentdays | Amount/Total | Average Payment Days by Customer |
| A | 10001 | 91,848 | 91,848 | 90 | 100% | 90 |
| A | 10002 | 337,930 | 337,930 | 45 | 100% | 45 |
| A | 10003 | 44,430 | 44,430 | 90 | 100% | 90 |
| A | 10004 | 355,695 | 355,695 | 45 | 100% | 45 |
| A | 10005 | 70,097 | 70,097 | 90 | 100% | 90 |
| 360 |
The customer and invoice are 2 separate tables but this shouldn't have any impact, right?
And I can only create measure in the report, and not directly creating the new measures in the data table.
Hi Catman ,
Thank you for sharing the update!
It might happening because the total amount by customer is being calculated at the invoice level instead of staying fixed for the customer. This happens when the visual includes invoice-level detail, and the measure does not ignore that context. To get the right weight % and average payment days, the total amount should remain the same across all invoices for a customer. Also, since your Customer and Invoice tables are separate, just make sure there is a proper relationship between them.
Hope this helps.
Thank you.