March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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 |
Solved! Go to Solution.
Hi,
You could try something like the measure below to only calculate if the actual field is not blank:
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
Hi,
You could try something like the measure below to only calculate if the actual field is not blank:
User | Count |
---|---|
122 | |
98 | |
89 | |
76 | |
68 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |