Incorrect column totals in final results

[BrianJ]

@BenBen2,

Your PBIX file didn’t upload, so I can’t say for 100% certain but I’m pretty sure that applying the approach in the thread below will solve your problem:

Showing only last balance

@BenBen2, Sure – see example below using your Current Balance measure. If you just drop Deposit Type and Current Balance into a Table visual, you’ll get this: [image] The Deposit Type rows work fine because they are defined in the initial data model, and the calculation is row by row, so IRA, Money and Share produce correct current balance results. However when Power BI gets to the Total row, it doesn’t have sufficient context to evaluate that row correctly, so it basically does this ¯\(ツ…

If it doesn’t, please repost your PBIX so that we can provide a more specific solution.

Thanks.

• Brian