Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Reasons for miscalculation

Hello everyone,

 

I have such an issue. For some reason, my calculation doesn't work as expected. 

I am trying to understand what can be the reasons for miscalculation. 

 

 The formula is   1 - ((ABS(Forecast-Actuals))/Actuals)

 

 

If I do it in Excel I get such numbers

 

 

 I am trying to understand what can be the reason for miscalulcation...

 

I am using a measure for calculation

 

 

Any idea will be grately appreciated. 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Anonymous wondering forecast or actual values are different when you are viewing these in the table. Can you create tow measures that is simple sum of forecast and actual, and drop these in the visual to see if the numbers are same as you highlighted.

     

    ✨ Follow us on LinkedIn

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.