Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF NOT BLANK Calculate Sum

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

 

WeekOutage DurationsC_Durations
119221
2401 
36023
4364777
5601 
6120300
77020
81050 
9150 
10490 
11188188
12195 
13360 
14140 
1548 
161801634
17497497
181784 
191160 
2060 
2130442
2221 
23107107
24180 
25487 
2610368
27538538

 

Need Help

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    if i understand you correct try SUMX()

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

     

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous,

     Regards FrankAT

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      Best regards,

      Don