Relationship or Matrix Problem?

[Anonymous]

Hi, everyone! I'm having trouble to understand what might be causing my issue.

I have two tables:

The First Table (Left) contains when and how many items we'll need to fabricate. The Second Table (Right) contains "Child Items", which are used to make one "Parent Item", and how many of it we need to make one of those said "Parent Items". I'm trying to create a Matrix of how many of these "Child Items" are needed over the Order Dates of their Parent Items: (Order Qty*Times Used). Something similar to:

These two tables have a Many By Many relationship using Item column as reference. I cannot change it because there is no other column I can use as reference to the "Child Items". I've achieved something almost as I wanted, but my totals are incorrect and I can't seem to understand why. I get something similar to:

I used a measure in the Values section of my matrix:
Values = SelectedValue('First Table'[Order Qty]) * SelectedValue('Second Table'[Times Used]).

Can someone point out what am I doing wrong and how can I achieve what I want?

[Daniel29195 · Accepted solution]

@Anonymous 

create the following table ; 

then just drag and drop columns to the visual and it should work as you want . 

NB: now for the used , if it is not on the date level, then dont add this column to the newly created table. 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍