Card visual - calculate difference between actual and budget

[garycarters]

I am trying to present a visual that shows the difference between average daily spend per month compared to the budgeted spend in a card.

I can display the Daily average with a column such as 

DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays])).

However, if I try to calcuate the difference by subtracting the budgeted daily figure (either as a constant or retrieved from a field) I get a strange result nowhere near the expected answer.

Things I've tried include;

DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays])) - 37859

DailyAvgVBudget = CALCULATE(SUM([Spend])/AVERAGE([MonthWorkingDays]) - AVERAGE(Budget[Daily]) )

Am I trying to achieve the impossible?  Surely not...

[v-frfei-msft]

Hi @garycarters ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[garycarters]

https://1drv.ms/u/s!Amo6JxqZkuIlad7zkbxiKSakac0 

This is the data set I am using.

[v-frfei-msft]

Hi @garycarters ,

Seemed that I cannot access the file by the link. Could you please share it again?

[garycarters]

Try again

https://1drv.ms/u/s!Amo6JxqZkuIlad7zkbxiKSakac0 

[v-frfei-msft]

Hi @garycarters ,

Same error..