Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |