Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Incorrect measure total combining two different tables

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:

Jdpatino21_0-1633053258457.png

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:

Jdpatino21_1-1633053410150.png

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.....

 

Jdpatino21_2-1633053588204.png

 



Any thoughts? 

 

I would really apreciate any help.



Status: New
Comments
v-chuncz-msft
Community Support

@Jdpatino21 

 

See links below for computing visual totals accurately.

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
Frequent Visitor

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