Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
yellow_old_5
Helper II
Helper II

Calculate difference 2 sales where we have sales

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

MonthBudgetActual
11000500
220001000
320001500
41000800
53000 
64000 
72000 
83000 
92000 
105000 
111000 
122000 
Total280003800
1 ACCEPTED SOLUTION
DOLEARY85
Super User
Super User

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]))))

View solution in original post

2 REPLIES 2
joaoribeiro
Impactful Individual
Impactful Individual

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:

joaoribeiro_0-1680263965143.png

 


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

DOLEARY85
Super User
Super User

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]))))

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.