Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum All Values in an If Statement

Hi, 

I created an if statment to use as a measure in a table, the column is 'Proj Sales Total' (See Full Table).

However, when the sum at the bottom is only totaling the 1st two rows (where the statement is true). 

 

 

The measure for this field is: 

Proj Sales Total = If( [WrittenSales] > 0, [WrittenSales] * .9, [ForecastCalculation])

 

Here are the measures being used in the above calculation:

WrittenSales = Sum('Table1'[Sales])

ForecastCalculation = sum('Table2'[Forecast])

 

How do I get the total to sum all the rows?

If I make thismeasure a calculated column, I get the same incorrect result. 

 

  • Anonymous try this measure

     

    Total Proj Sales = 
    SUMX ( VALUES ( Table[Fund Day] ), If( [WrittenSales] > 0, [WrittenSales] * .9, [ForecastCalculation]) )

     

2 Replies

  • Anonymous try this measure

     

    Total Proj Sales = 
    SUMX ( VALUES ( Table[Fund Day] ), If( [WrittenSales] > 0, [WrittenSales] * .9, [ForecastCalculation]) )

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello I am working with this currently. I have an if statment that places a 0 if a negative. When I add it to the visual it does not total the row. I attempeted the formula above but I cannot reference my two fields I need or the orginial measure.