Cant subtract a column from a measure from another table

[Anonymous]

Hi guys,

Power BI is not working how i would think. I am attempting to subtract a column (Smelter load forecast) from a measure (Total Smelting Load):

The values of "Smelter Forecast vs Actual Delta" are way too large:

I cant help but think that somehow my "date" linking is messing something up even though they have 1:1 relationships: 

Any guidance would be appreciated. Thanks.

[Anonymous · Accepted solution]

I figured it out. I needed to create a measure and subtract the summed columns from eachother: 

Smelter Forecast vs Actual = sum('Forecast'[Smelter Load Forecast])-sum('Load Data'[Total Smelting])

Thanks guys.

[Anonymous]

Can you set the relationships to Single direction and if that changes thte values? I always like to avoid multiple dual directional filters.

[Anonymous]

Good tip. It didnt change any values however.