cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
 
LineCME BudgetAmount BilledEst To CompEst 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
Super User IV

@Keyla2020 , Try like

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

or

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User II
Super User II

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

 





Hope it resolves your issue? 
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
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

 

 

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.

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

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

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors