Forum Discussion
Averagex Measure Excluding Blanks
Hello! I am comparing two periods. For previous period I am using SAMEPERIODLASTYEAR. My measure is doing some basic calculations but it filters out values that dont exist in both columns. ...
fireflyxxoo , This seems fine and should not consider blank. but will consider 0
AVERAGEX(VALUES(Table[Customer]),[Measure])
And with date/calendar table
CALCULATE(AVERAGEX(VALUES(Table[Customer]),[Measure]),SAMEPERIODLASTYEAR('Calendar'[Date]))
Thanl you so much but when I do
AVERAGEX(VALUES(Table[Customer]),[Measure]) it doesnt return an average for the entire column. It forces me to do ALLSELECTED() to get 1 number but when I utilize all selected it's smaller number than when I do mean by hand..:(