Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |