cancel
Showing results for
Did you mean:
New Member

## Delta Measure Issues

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

5 REPLIES 5
Super User IV

@Keyla2020 , Try like

or

Proud to be a Super User!

Super User II

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

Regards,
Pranit

Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit
Microsoft

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

New Member

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.

Microsoft

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

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!