Table relationship not working

Iron Contributor

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


Screenshot 2023-02-16 at 2.56.12 PM.pngScreenshot 2023-02-16 at 3.00.13 PM.png








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

Screenshot 2023-02-16 at 3.14.26 PM.png


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

Screenshot 2023-02-16 at 3.14.34 PM.png Screenshot 2023-02-16 at 3.13.19 PM.png Screenshot 2023-02-16 at 3.14.44 PM.png

1 Reply
best response confirmed by AndrewX (Iron Contributor)
1 best response

Accepted Solutions
best response confirmed by AndrewX (Iron Contributor)