Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SUM a nested CALCULATE within a SummarizeColumns?

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's avatar
    Anonymous
    6 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    Well... instead of asking here you could just do what you suggest and see if it works 🙂

    However,

    Best
    D
    • Anonymous's avatar
      Anonymous
      Not applicable
      Of course, there's no "however"...

      Best
      D
    • Anonymous's avatar
      Anonymous
      Not applicable

      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