IF NOT BLANK Calculate Sum

[dcg38524]

Hello,

I need your help - we have 2x columns "Outage Durations" & "C_Durations" we would like to calculate the Sum of column "C_Durations" 1st if the column/row is not Blank.

If somehow "C_Durations" column/row is BLANK then calculate sum of column/row "Outage Durations".

Any advice would be greatly appreciated,

Thank you

Week	Outage Durations	C_Durations
1	192	21
2	401
3	60	23
4	364	777
5	601
6	120	300
7	70	20
8	1050
9	150
10	490
11	188	188
12	195
13	360
14	140
15	48
16	180	1634
17	497	497
18	1784
19	1160
20	60
21	30	442
22	21
23	107	107
24	180
25	487
26	103	68
27	538	538

[FrankAT · Accepted solution]

Hi @dcg38524,

 Regards FrankAT

[dcg38524]

Thank you very much, your DAX logic / solution worked perfectly.

Best regards,

Don

[az38]

Hi @dcg38524 

if i understand you correct try SUMX()

= CALCULATE(SUMX('Table', IF(ISBLANK([C_Durations]), [Outage Durations], [C_Durations]) ) )