Displaying correct grand total for custom measures

[lennyt99]

What do I need to add to my dax to get the grand total for these measures? It needs to sum up correctly the entire column. I'm attaching here 2 measures that need to display the grand total at the bottom. 

THanks!

YTD =

IF (

HASONEVALUE ( 'Fiscal Year Conversion'[Fiscal Year] ),

CALCULATE (

SUM ( 'Opportunity Tracker 2.0'[Annual Volume LBS] ),

FILTER (

ALL ( 'Fiscal Year Conversion' ),

'Fiscal Year Conversion'[Fiscal Year] = VALUES ('Fiscal Year Conversion'[Fiscal Year] )

&& 'Fiscal Year Conversion'[Calendar Date] <= MAX ('Fiscal Year Conversion'[Calendar Date] )

)

)

)

LY YTD Variance = IF(ISBLANK([YTD]), BLANK(),

IF(ISBLANK([LY YTD]), BLANK(),

[YTD]-[LY YTD]))

[latimeria]

Hi @lennyt99 ,

You need to define the calculation at total level (when more than 1 value).

No else in your statement

YTD =
IF (
    HASONEVALUE ( 'Fiscal Year Conversion'[Fiscal Year] ),
    CALCULATE (
        SUM ( 'Opportunity Tracker 2.0'[Annual Volume LBS] ),
        FILTER (
            ALL ( 'Fiscal Year Conversion' ),
            'Fiscal Year Conversion'[Fiscal Year]
                = VALUES ( 'Fiscal Year Conversion'[Fiscal Year] )
                && 'Fiscal Year Conversion'[Calendar Date]
                    <= MAX ( 'Fiscal Year Conversion'[Calendar Date] )
        )
    ),
    // else total?? 
)

[lennyt99]

What would the else total be?