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 as requested the test file with the same problem
https://we.tl/t-QXVLdlIibV
lbendlin
Super User
Super User
Ø / Monat =
var a = SUMMARIZE('Tabelle1 (2)','Tabelle1 (2)'[Art Nr],'Tabelle1 (2)'[Sale Date].[Month],"s",sum('Tabelle1 (2)'[Quantity]))
return AVERAGEX(a,[s])