Hi, I have searched through many forum topics and videos, but I can’t seem to get the logic required for this. I’m doing some Variance analysis on current year Sales, forecast and budget, plus budget for next year. Budgets and Forecasts are based on sales last year * Growth Rate. The rows return th…

@Irene Wrap all your measure inside SUMX ( VALUES ( Dates[FY Month] ), [Measure] ) construct, I did it for a few. Test Model.pbix (1.5 MB)

Totals not summing

Greg September 1, 2020, 1:33pm 3

Hi @Irene. You can check out the Fix Incorrect Totals pattern post as well. Hopefully it will have something to help. Greg