Aggregate column with Blank values

[nadavsn]

Hi all
I am trying to create a measure that returns the AVERAGE of whole number column that includes BLANK. I want the measure to ignore these rows with blank on it.
I tried:
MaxDeleteBucketGap = CALCULATE(
AVERAGEX('Random_Tests_Buckets','Random_Tests_Buckets'[Sleep Day]),FILTER('Random_Tests_Buckets','Random_Tests_Buckets'[Sleep Day]=BLANK()))

and

MaxDeleteBucketGap =
AVERAGE('Random_Tests_Buckets'[Sleep Day])
I don't get an error but I don't get any value either.
Any help will be much appreciated.
Nadav

[AlB · Accepted solution]

Hi @nadavsn 

AVERAGE and AVERAGEX already ignore blanks. With your first piece of code you are keeping only thre blanks for the AVERAGEX:

MaxDeleteBucketGap = CALCULATE(
AVERAGEX('Random_Tests_Buckets','Random_Tests_Buckets'[Sleep Day]),FILTER('Random_Tests_Buckets','Random_Tests_Buckets'[Sleep Day]=BLANK()))

[nadavsn]

Thanks!

It turned out to be a slicer problem. 

AVERAGE and AVERAGEX do ignore BLANK.