Forum Discussion
Solved
Finding Average Unit Price Across Invoices
Very new to Measures and struggling to wrap my head around this. It's probably going to be quite simple once I see the answer. Invoice Product Quantiy Unit Price INV001 Apple 3 $5.00 ...
Avg Unit Price Per Invoice =
AVERAGEX(
VALUES('Invoice Lines (2) Dim'[Invoice]),
CALCULATE(AVERAGE('Invoice Lines (2) Dim'[Unit Price]))
)
This gives you the average unit price per invoice, not weighted by quantity—just like your example. Clean, accurate, and context-aware.
Hi cparker4486 , Thank you for reaching out to the Microsoft Fabric Community Forum.
I reproduced the scenario on my end using sample data and it worked successfully. To help you better understand the implementation, I’ve attached the .pbix file for your reference. Please take a look at it and let me know your observations.
Thank you for being part of the Microsoft Fabric Community!