Exclude Blanks in Measure

[jcastr02]

Is there a way to tailor this measure so that it excludes blanks in the "Closure Date" column?

Avg After Closing Date = 
VAR vTable =
    CALCULATETABLE (
        SUMMARIZE ( 'Table', 'Table'[Str Number], 'Table'[Daily Sales] ),
        'Table'[Date] >= 'Table'[Closure Date]
    )
VAR vResult =
    AVERAGEX ( vTable, 'Table'[Daily Sales] )
RETURN
    vResult

[danextian]

Hi @jcastr02 

Is this a measure and you want to exlude blank closure date from calculating the average? Try:

Avg After Closing Date =
VAR vTable =
    CALCULATETABLE (
        SUMMARIZE ( 'Table', 'Table'[Str Number], 'Table'[Daily Sales] ),
        'Table'[Date] >= 'Table'[Closure Date]
            && NOT ( ISBLANK ( 'Table'[Closure Date] ) )
    )
VAR vResult =
    AVERAGEX ( vTable, 'Table'[Daily Sales] )
RETURN
    vResult

[Jihwan_Kim]

Hi, 
I am not sure if this is a measure or a calculated column, but please try something like below whether it suits your requirement.

Avg After Closing Date =
VAR vTable =
    CALCULATETABLE (
        SUMMARIZE ( 'Table', 'Table'[Str Number], 'Table'[Daily Sales] ),
        'Table'[Date] >= 'Table'[Closure Date]
    )
VAR vResult =
    AVERAGEX ( vTable, 'Table'[Daily Sales] )
RETURN
    IF ( NOT ISBLANK ( 'Table'[Closure Date] ), vResult )

[jcastr02]

@Jihwan_Kim thanks for quick reply this is a measure.  It seems it's not allowing me to add the column closure date in the return portion.