SUM a nested CALCULATE within a SummarizeColumns?

[Patto]

Hi all

Hoping I can get some quick help on this.
I have the following CALCULATE statement inside a SUMMARIZECOLUMNS and I want to wrap it in a SUM.

--This is my current calculate statement which works a treat. It is just calculating a column and putting 0 where I have blanks in another calculation.
CALCULATE(
    IF(
        ISBLANK(
            CALCULATE(
                SUM('Measures - Load Planning'[EFTSL])
                ,'Load Cycle'[Load Cycle Month Day] = "October 31"
                ,'Load Year'[Load Year Cycle] = -1
                ,'Progress Category'[Progress Category Code] = "CT1"
            )
        )
    ,0
    ,CALCULATE(
        SUM('Measures - Load Planning'[EFTSL])
        ,'Load Cycle'[Load Cycle Month Day] = "October 31"
        ,'Load Year'[Load Year Cycle] = -2
        ,'Progress Category'[Progress Category Code] = "CM1"
    )
    )
)


All I want to do now is basically wrap that whole thing in a
CALCULATE(
    SUM( {above statement here})
    ,ALLSELECTED(a column on the table)
)

Does this make sense? Can anyone help?
Cheers

[Anonymous]

Well... instead of asking here you could just do what you suggest and see if it works 🙂

However,

Best
D

[Patto · Accepted solution]

Hi

Yeah that was one of the first things I tried but it didnt work.
In the end I managed to get it working by creating another calculated table off the original and doing my calcs in there.
Thanks anyway.
Cheers

[Anonymous]

Of course, there's no "however"...

Best
D