Need help with Matrix only showing sums from one table. Please

[bsharp]

Hello. I'm trying to build a matrix that shows. 

Qty invoiced comaprred to qty on replenishemnt for my company. I've attached a screen shot below. The indivdual warehouses match in both tables but when I add the replenishment value to the matrix on the left every line reports back as the sum of all. 

Can anyone suggest a way around this? 

The relationships are built on the stock codes and seem to function right otherwise. 

Thanks!

[Rigensis]

@bsharp I take it that quantity invoiced and replensihments are coming from two different tables, could you please show how these tables are connected in the model?

[amitchandak]

@bsharp , With Common Stock(Srock code) dimension you should be able to analyze them together

https://www.seerinteractive.com/blog/join-many-many-power-bi/

[bsharp]

I've got the relatiionships built. Everything else seems to be working I jsut can't understand why the replenishment colum in the matrix on the left is summing every line. It should show the values in the matrix on the right for those same lines. 

Am I missing something? 

Thanks!

[v-kelly-msft]

Hi @bsharp ,

What kind of relationship have you built?How about the direction between the relationship?

If possible,could you pls share your sample .pbix file for a test?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!