topic Re: SUM a nested CALCULATE within a SummarizeColumns? in DAX Commands and Tips

SUM a nested CALCULATE within a SummarizeColumns?

Anonymous — Thu, 16 Apr 2020 22:52:52 GMT

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

Re: SUM a nested CALCULATE within a SummarizeColumns?

Anonymous — Fri, 17 Apr 2020 12:43:42 GMT

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

However,

Best
D

Re: SUM a nested CALCULATE within a SummarizeColumns?

Anonymous — Fri, 17 Apr 2020 12:44:10 GMT

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

Best
D

Re: SUM a nested CALCULATE within a SummarizeColumns?

Anonymous — Wed, 22 Apr 2020 07:28:20 GMT

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