Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi everyone!
I've got a sales table like this:
My intention is to calculate the average value of of sales, where a sale is identified by the filed DocNo and its value is given by the sum of the single items' values:
In this example the average would be (1200+6700+5500)/3 = 4467 €
How can I do it in DAX? Thank you!
Solved! Go to Solution.
pls try this
Measure = averagex(VALUES('Table'[DocNo]),CALCULATE(sum('Table'[sale value]),ALLEXCEPT('Table','Table'[DocNo])))
Proud to be a Super User!
pls try this
Measure = averagex(VALUES('Table'[DocNo]),CALCULATE(sum('Table'[sale value]),ALLEXCEPT('Table','Table'[DocNo])))
Proud to be a Super User!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.