Totals not summing

DAX DAX Calculations
1

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 the right numbers, but the total is incorrect. Financial year is Oct to Sep which is working ok.

When I compare forecast to last year again it’s returning the right rows, but wrong total. Same when I’m calculating cumulative.

Total Error
Total Error1434×796 433 KB

Test model below. I’ve removed sensitive data, but structure is basically the same as full model.

Test Model.zip (1.4 MB)

Any help greatly appreciated.

Many Thanks
Irene

2

@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)

3

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

4

@AntrikshSharma Thank you so much! Easy when you know how :smiley:

1 Like
5

Thanks @Greg , I will check it out.