Forum Discussion

BeeleJa's avatar
BeeleJa
Helper I
1 year ago
Solved

SUMX calcuation error

I am trying to calculatethe child_WO total revenue and keep ending up with the amoun for the 100-5_IRE02 being added twice where only one value should be taken for the QTY 1 (or above 0) Value I am ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    BeeleJa 

    you can try this

     

    Column = sumx(FILTER('Table','Table'[Child_WO]=EARLIER('Table'[Child_WO])&&'Table'[QTY]>0),'Table'[Revenu])
     
     
    pls see the attachment below
BeeleJa's avatar
BeeleJa
Helper I
1 year ago

Hello Ryan

Somehow the formula provided is not working in myh full live version

specifically for the child_WO W00046130105 It is still adding another 1729.37

I expect in relation to the item 0-5_IRE02 that is there twice, once with the QTY zero and once with the QTY 1

 

Any thoughts on how to improve the formula in another way, for example with using 'VAR' declarations ?

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    BeeleJa 

    Is this part that what you are mentioning?

     

     

    I checked your sample data. It's the same as what you expected.

     

    pls update the sample data and expected output.

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      1 year ago

      Hi BeeleJa,

      May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

      Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi BeeleJa,
    I wanted to check if you had the opportunity to review the information provided by ryan_mayu . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi BeeleJa,

     

    We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

     

    Thank you.