Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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])
@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?
@Anonymous , it is new column name inside summarize
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
48 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |