Forum Discussion
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
- parry2kSuper User
Anonymous try this measure
Total Proj Sales = SUMX ( VALUES ( Table[Fund Day] ), If( [WrittenSales] > 0, [WrittenSales] * .9, [ForecastCalculation]) )- AnonymousNot 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.