The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
Third time I write this topic.. Website is not helping me out today, haha. Hopefully you guys can 🙂
I need to calculate the average after a sum of the invoices.
Sample below:
Amount | Invoice Number | ACTUAL INVOICE AMOUNT | |
€ 100.00 | 19700091 | ||
€ 200.00 | 19700091 | ||
€ 150.00 | 19700091 | 250 | |
€ 250.00 | 19700091 | ||
€ 10.00 | 19700095 | ||
€ 20.00 | 19700095 | 20 | |
€ 30.00 | 19700095 | ||
€ 5.00 | 19700100 | ||
€ 10.00 | 19700100 | ||
€ 20.00 | 19700100 | 15 | |
€ 20.00 | 19700100 | ||
€ 10.00 | 19700100 | ||
Average: 68,75 | Average: 95 |
What I need is 95 as outcome, but currently I have 68,75. How do I fix this? I suppose it's easy but I can't get my head around it.
Thank you in advance for helping me out!
Below is my measure:
1. Factuur Gemiddelde =
CALCULATE(
//Average berekening
AVERAGEX(
SUMMARIZE(TransactionLinesBulk,TransactionLinesBulk[InvoiceNumber], TransactionLinesBulk[Bedrag]),
TransactionLinesBulk[Bedrag]),
//Filters
LEFT(GLAccountClass[ClassificationCode],4)="WOmz",
TransactionLinesBulk[InvoiceNumber] > 0,
TransactionLinesBulk[Bedrag] <> 0
)
Solved! Go to Solution.
@Anonymous , Try like
averageX(summarize(Table,table[Invoice Number], "_1",sum(Table[Amount])),[_1])
Hi @amitchandak ,
Thanks! Works like a charm. Can you explain what the _1 is and why it works like that?