Total Sum of IF Statement

[Anonymous]

Hi I am calculating Growth based on two measures and conditions, I am able to see the calculation in the column but am unable get a total of the same column. Any help would be appreciated.

Measure: 

Growth = IF([PY TTM M-1] = 0 && [TTM M-1] > 0, CALCULATE([TTM M-1] - [PY TTM M-1]),0)

Thanks!

[themistoklis]

@Anonymous

Put calculate in front of the if statement:

[Kristjan76 · Accepted solution]

This is because the measure [PY TTM M-1] = 493.2633.663 in the total row, since this does not equal zero, the if statement returns FALSE, hence = 0.

If you want to sum over the Growth then you could do something like this. I did not test this so there might be spelling errors.

Growth 2 = 
IF(
  HASONEVALUE([Global Customer Number]),
  [Growth],
  SUMX(  
    ADDCOLUMNS(
      SUMMERIZE(
        myTable,
        myTable[Global Customer Number]
      ),
      "growth val", [Growth]
    ),
    [growth val]
 )

[Anonymous]

I tried your solution but I ran into memory issues since my dataset is large. Is there a workaround?