Incorrect measure total combining two different tables

[Jdpatino21]

Hello everybody, I´m having the following issue: I create a measure that bring either the actual budget execution or my budget to complete.... as I show next:

Table 'contabilidad Balance_Prueba' is the actual execution

Table Presupuesto is the budget

tables 'Ajustes EEFF' and 'Ajustes Forecast' are managerial adjustments.

However, when I display then on a table look what it happen:

I have actual from Jan to Aug... and forecast from Sept to dec..... if you take a closer look you will see that the total amount is not the sum of the 12 months.....

Any thoughts? 

I would really apreciate any help.

[v-chuncz-msft]

@Jdpatino21 

See links below for computing visual totals accurately.

• https://community.powerbi.com/t5/Desktop/Incorrect-Measure-Total/m-p/454679
• https://www.sqlbi.com/articles/obtaining-accurate-totals-in-dax/

By the way, for questions about data shaping, modeling, and report building in the Power BI Desktop app, post a new message in Desktop forum.

[Jdpatino21]

@v-chuncz-msft  thank you I will look into it! adn repost it in case that I don found any answer!