Table/Matrix changes based on measure formula

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.