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