Delta Measure Issues

[Keyla2020]

I created a measure that finds the delta between two values, as shown below,

CME Delta = SUM('Milestone Data'[CME Budget])-ABS('ad (2)'[EAC])

The issue I'm having is that it works for some lines and it doesn't for others and I have no idea why!!!

As you can see below, line 2 is not calculating properly with the CME Delta output

Line	CME Budget	Amount Billed	Est To Comp	Est At Comp	CME Delta
1	$5,248,197.27	$116,608	$6,675	$123,283	$    5,124,914.57
2	$1,098,000	$224,264	$321,876	$546,140	$    1,649,859.74
3	$671,106.57	$0	$34,157	$34,157	$       636,949.62
4	$599,000	$0	$48,792	$48,792	$       550,208.02

[amitchandak]

@Keyla2020 , Try like

SUM('Milestone Data'[CME Budget])-sum(ABS('ad (2)'[EAC]))

or

SUM('Milestone Data'[CME Budget])-ABS(sum('ad (2)'[EAC]))

[Anonymous]

Hi @Keyla2020 

The column 'CME Budget' and 'EAC' in the screen shot doesn't look like a number column. As the number column will be right aligned as in the last column 'CME Delta'.

Can you confirm the columns used in the calculation are number, if not convert them to number and try the formula.

If they are number column try using the below formula instead with an ABS for SUM().

CME Delta = ABS(SUM('Milestone Data'[CME Budget]))-ABS('ad (2)'[EAC])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Regards,
Pranit

[v-deddai1-msft]

Hi @Keyla2020 ,

Your issue is not very clear to me. Would you please show us some more details?  You may try the following measure:

CME Delta = SUM('Milestone Data'[CME Budget])-ABS(SUM('ad (2)'[EAC]))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Keyla2020]

This is complicated to explain in words, due to this Power BI dashboard being a rats nest. I wish I could share my screen and we can walk through it. Is there a measure I can use to overwrite the output?

Meaning, I want to manually input CME Delta value for those two projects.

[v-deddai1-msft]

Hi @Keyla2020 ,

I really can’t understand the output you want, please explain your needs in detail otherwise it will be difficult for us to help you.

Best Regards,

Dedmon Dai