Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table/Matrix changes based on measure formula

Dear community, I am trying to calculate the forecast accuracy of three products, and I have observed some strange behavior that I can't explain. The data I have two input tables: Forecasts and Me...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    According to your pictures, I created the same data tables as yours, and I created this measure and place the columns like this, you can take a look:

    Error =

var _error=DIVIDE(SUM(Forecasts[Absolute Deviation]),SUM(Forecasts[Demand]))

return 1-_error

     

    And I guess this is what you want.

    You can download my test pbix file here

     

    Best Regards,

    Community Support Team _Robert Qin

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

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

According to your pictures, I created the same data tables as yours, and I created this measure and place the columns like this, you can take a look:

Error =

var _error=DIVIDE(SUM(Forecasts[Absolute Deviation]),SUM(Forecasts[Demand]))

return 1-_error

 

And I guess this is what you want.

You can download my test pbix file here

 

Best Regards,

Community Support Team _Robert Qin

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