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

thx for the quick response

how can I integratw this to the child wo value, my data set has multiple child wo under a single wo and multiple wo inclusing child wo

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi BeeleJa 

If the columns are from the same table, Jihwan_Kim 's solution should work. Can you please be more specific?