Forum Discussion

AndrewX's avatar
AndrewX
Iron Contributor
Feb 16, 2023

Table relationship not working

I have a simple setup, 1x csv called costs, 1x csv called orders.

 

 

 

 

 

 

 

 

I added them to the data model, and made a relationship on the product column.  I then created a powerpivot table and was hoping to sum the costs by product and/or name, but it wont calculate properly.  

 

Any clues?

 

Not calculating properly

 

Even though it is complaining about the relationship, i have already set that up.