Hi AlexMartini,

Your budget and actuals data are in same column, you want to create measure based the column, right? From what I know, you can use filter to calculate budget or actuals separately. I try to reproduce your scenario and create the below sample data.

Calculate the sum of budget using the measure: Actuals:=CALCULATE(SUM(Table11[amont]),FILTER(Table11,Table11[Category]="Actuals"))

Calculate the sum of budget using the measure: Buget:=CALCULATE(SUM(Table11[amont]),FILTER(Table11,Table11[Category]="Budget"))

Calculate the difference between budget and actuals using the measure: varience:=[Actuals]-[Buget]

Then create a pivot table, select the Category as Rows, above three measures as Values, it will calculated according to the rows. From the screenshot, the 507 highlighted in yellow is obtained by 507 subtracts 0, the -464 in red line is obtained
by 0 subtracts 464.

While, we will get the right difference when just select the varience measure as Values, like below picture.

If this is what you want, please share more details or sample data for further analysis.

Best Regards,

Angelia