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
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper 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
Icon for Community Support rankCommunity 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.