Calculate difference 2 sales where we have sales

[Anonymous]

Hi
I need to sum the difference between budget and actual but only where we can compare like mont 1 to 4

Month	Budget	Actual
1	1000	500
2	2000	1000
3	2000	1500
4	1000	800
5	3000
6	4000
7	2000
8	3000
9	2000
10	5000
11	1000
12	2000
Total	28000	3800

[joaoribeiro]

Hi,

You can use the CALCULATE function and filter the rows where the actual is blank, as shown below:

Difference = 
CALCULATE(
SUMX('Table', [Budget] - [Actual]),
NOT ISBLANK('Table'[Actual])
)

Result:

Find more details in:
https://learn.microsoft.com/en-us/dax/calculate-function-dax

[DOLEARY85 · Accepted solution]

Hi,

You could try something like the measure below to only calculate if the actual field is not blank:

Measure = if(isblank(CALCULATE(sum('Table'[Actual]))),blank(),CALCULATE(sum('Table'[Budget])-CALCULATE(sum('Table'[Actual]))))