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,
Wouldn't you want to calculate the weighted average price instead?
That would also be good to know. Please provide the formula if you can. Thank you.
Try this measure
Avg. Unit Price = SUMX('Invoice Lines (2) Dim', 'Invoice Lines (2) Dim'[Unit Price]*'Invoice Lines (2) Dim'[Quantity]) /sum('Invoice Lines (2) Dim'[Quantity])