Help with comparing Actual vs (multiple) Forecast values

Hello MFelix Thank you for your reply. I tried out the formula you reccomended unfortunately I was still getting the same result of only the Actual Row subtracting itself.

My data set includes a table for forecast, and a table for actual values. In my post I showed the combined data set to make it easier to view and to see if I can see a simple dax formula solution to my issue.

I was able to come up with a solution by merging queries together. So I joined the Actuals table to my Forecast table based on Attribute and Date matching up and I was able to have an Actuals Value column next to the Forecast Value Column and I created a new column subtracting the Forecast Value from the Actual Value.