Forum Discussion

gorankocinski's avatar
gorankocinski
New Member
8 years ago
Solved

New column sum formula help

hi, I have one document with 2 tables in it. In the first table there are 2 columns  A with unic ID of some business and B with given funds by state. for example    Table name - GivenFunds ID,...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Greg_Deckler,

     

    In your scenario, have you created any relationship between the two tables? If not, please create one. Then you can try following calculated column:

     

    Column =
CALCULATE (
    SUM ( SecondTable[Cost] ),
    FILTER ( FirstTable, FirstTable[ID] = EARLIER ( FirstTable[ID] ) )
)

     

    And once you create the relationship Greg_Deckler's solution should not return errors.

     

    Thanks,
    Xi Jin.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Assuming a relationship between the tables:

 

Column = SUMX(RELATEDTABLE(IndividualCosts),[Cost])
  • gorankocinski's avatar
    gorankocinski
    New Member
    8 years ago

    Greg_DecklerI get error with this type of formula saying "Too many arguments were passed to the RELATEDTABLE function. The maximum argument count for the function is 1"

     

    btw in the first table i have arround 100 unique ID's, and in the socond table i have arround 2 milion individual_cost rows