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
Jihwan_Kim's avatar
Jihwan_Kim
Super User
1 year ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

revenue_child_wo: = 
SUMX( 
    CALCULATETABLE('Table', REMOVEFILTERS()), 
        'Table'[QTY] * 'Table'[Revenue]
        )

 

BeeleJa's avatar
BeeleJa
Helper 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
    Super 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?