Forum Discussion
Helper IIAggregation measure - is locking an aggretation level an option?
Chava1881 this measure will give you correct Error sum and then you can further add measure to us this Error measure
Error = SUMX ( VALUES ( 'Aggregated-Data'[Category] ), ABS ( CALCULATE ( SUM ( 'Aggregated-Data'[ORDERS] ) )- CALCULATE ( SUM ( 'Aggregated-Data'[Forecast] ) ) ) )✨ 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.⚡
Super UserChava1881 is this what you are looking for?
✨ 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.⚡
Chava1881Unfortunately not, I need to Total number or WW number to be 18%. The issue I am having is that the right way to calculate it in excel is as shown in the screenshot below:
B2 is summing all FCSTC2 is summing all Orders
D2 is summing the error at the category level.
When using my measure it goes calculating the error by using the total sum of forecast and orders, making the MAPE 1%, and if I create a calculated column, as there are different regions and subregions, the error is higher than calculating it as shown in the excel.
Hope this makes sense.