Forum Discussion

GUSers's avatar
GUSers
Regular Visitor
3 years ago
Solved

SUMX across three Tables

I'm struggling to figure out how to apply some calculations across three tables. I've been able to get SUMX to work with two of these tables with direct relationship, but now I've added a third table...
Need Help
  • GUSers's avatar
    GUSers
    3 years ago

    Thanks for the response. For whatever reason I continue to get the following error/warning message:

    • The column 'Cost[MfgCost]' either doesn't exist or doesn't have a relationship to any table available in the current context.

    I don't understand because the relationship appears in the Model just as I'd included in the screen shot above.

    • Many (Work) to One (Cost)

    I found some stuff online regarding doing Joins. So I joined tables and created a new table with the data that I was looking for. It seems a little clunky, but easier than fiddling with formulas that I was striking out on for awhile.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

GUSers , Create a work a new column work table 

 

Cost 1 = related ('Cost'[MfgCost])

 

then create a new column in the Events

 

Cost 2 = related(Work[Cost 1])

GUSers's avatar
GUSers
Regular Visitor
3 years ago

Thanks for the response. For whatever reason I continue to get the following error/warning message:

  • The column 'Cost[MfgCost]' either doesn't exist or doesn't have a relationship to any table available in the current context.

I don't understand because the relationship appears in the Model just as I'd included in the screen shot above.

  • Many (Work) to One (Cost)

I found some stuff online regarding doing Joins. So I joined tables and created a new table with the data that I was looking for. It seems a little clunky, but easier than fiddling with formulas that I was striking out on for awhile.