Remove nulls from a list in Paginated Report Builder

[JemmaD]

I have a parameter for users to select the quarter of the year so the list should be 1 to 4. 

When I run the parameter query there is a null (see screenshot). I think it's causing issues for other paramaters, is there a way to remove this null?

[DanIvanek]

This also helped me with select all as a default value. I was strugling with it for so long. 

[negi007 · Accepted solution]

@JemmaD 

Method 1:

EVALUATE
FILTER(

SUMMARIZECOLUMNS(
    'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())

Method 2

EVALUATE
FILTER(

DISTINCT(
    'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())

Method 3

EVALUATE
FILTER(

DISTINCT(
    'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())