Forum Discussion

ammartino44's avatar
ammartino44
Icon for Helper III rankHelper III
9 years ago
Solved

Help with relatedtable function

Hello. I'm tryiing to find    =SUMX(Filter(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),'Work Orders1'[WO Type]="Cashout")
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi, ammartino44

     

    From your formula, the data type of column 'Work Orders1'[WO Type] is text, while SUMX function evaluates to numbers or dates and cannot work with values of type String. Beside, the correct syntax of SUMX is: 

    SUMX(<table>,<expression>)

     

    In your scenario, the formula might be like :

    =SUMX(FILTER(RELATEDTABLE('Work Orders1'),'Work Orders1'[WO Type]="Cashout"),ColumnName)

     

    Best regards,
    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Gonna need more info on this one but... your formula does "look weird".   The general form of SUMX is:

  =SUMX(Table1, Expression)

 

It walks each row of the Table1, and evaluate the Expression... then adds the results together.

 

Your expression is :   'Work Orders1'[WO Type]="Cashout"  

 

That seems like a weird expression!