Forum Discussion

BeeleJa's avatar
BeeleJa
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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 ?

 

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity 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.