Forum Discussion
Using IF statement not resulting in correctly summed data
Using the following formula to combine two measures: NS Act+Proj = if([NS Act Total]=0,[NS Proj Total],[NS Act Total]) What I want it to do is create a column where "When [NS Act Total] is ze...
Bump
Just to clarify, you are happy with the measure as it exists on the table, but when it is summarized at the grand total level, you want it to sum the two measures together?
Right. I'm using the IF statement to create a measure of the full year's activity for 2017... combine Actual where I have it, and Projected where I don't, to give me the entire 2017.
Critical to that end is the ability to use it like any other measure... sum, divide, and add to other metrics. But the summation isn't working, and neither are other operations working with it. Key issue that I've run into is that, asked to sum over Jan 2017 - Dec 2017, it only adds up the [NS Act Total], not the whole thing.
Could you share your .pbix file?