Forum Discussion
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
- Anonymous6 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
- AnonymousNot applicableWell... instead of asking here you could just do what you suggest and see if it works 🙂
However,
Best
D- AnonymousNot applicableOf course, there's no "however"...
Best
D - AnonymousNot 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