Forum Discussion

Keyla2020's avatar
Keyla2020
New Member
6 years ago

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

 

Need Help

5 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Keyla2020
      New Member
      6 years ago

      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's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Keyla2020 , Try like

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

    or

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