Table relationship error?

[SueKi]

Hi, I have 3 tables in a file:

ItemAttr - contains information about every item, such as make / Buy, Planner Code, Value Stream
InvCat - Has an inventory category for each item - FG, RM or SemiFinished
OhHand - On Hand inventory qty and value for all items on hand.

I've created relationships and tried to pivot, so I get Item, Value Stream, Inventory Cat, On Hand Value - but the relationship isn't working. I'm getting every value stream for each item and every Inventory Cat, etc, etc.

Where am going wrong?

 

[SueKi]

Hi, I have 3 tables in a file:

ItemAttr - contains information about every item, such as make / Buy, Planner Code, Value Stream
InvCat - Has an inventory category for each item - FG, RM or SemiFinished
OhHand - On Hand inventory qty and value for all items on hand.

I've created relationships and tried to pivot, so I get Item, Value Stream, Inventory Cat, On Hand Value - but the relationship isn't working. I'm getting every value stream for each item and every Inventory Cat, etc, etc.

Where am going wrong?

View attachment 65435View attachment 65436

I noticed that ItemAttr to InvCat is many to one, instead of one to one. That is incorrect, but I can't see where to change it. I've reconfigured to have ItemAttr and InvCat both connect many to one with OnHands, but it doesn't change my result

 

[RoryA]

You need to add a value field to the pivot table.

 

[SueKi]

You need to add a value field to the pivot table.

OMG! That easy! I make regular pivots sometimes without values, never thought that could be the issue. Thank you so much!

 

[RoryA]

What can I say - DAX and the data model are a bit weird.