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.
2 Comments
v-chuncz-msftCommunity Support
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.
v-chuncz-msft thank you I will look into it! adn repost it in case that I don found any answer!
