Forum Discussion
Average is not calculated correctly Need Help
Hello I need your help again, here is the measure for it. Ø / Monat = ROUNDUP(AVERAGEX( VALUES('Date (2)'[Date].[MonthNo]), CALCULATE([Verkauft]) ),0 ) U...
lbendlin
Super User
Super UserPlease provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin as requested the test file with the same problem
https://we.tl/t-QXVLdlIibV
- lbendlin
Ø / Monat = var a = SUMMARIZE('Tabelle1 (2)','Tabelle1 (2)'[Art Nr],'Tabelle1 (2)'[Sale Date].[Month],"s",sum('Tabelle1 (2)'[Quantity])) return AVERAGEX(a,[s])