Measure values not calculated by table column

[Ed_Beach]

Hi,

Reference: Global Superstore dataset

I would like get the total quantity of returned items by year but I am getting the total quantity of returns in entire dataset as shown below:

No of returns not tabulated by year

 Below shows the relationship established:

Relationship established as shown via order ID

Any help here? Thanks! I would like to know what went wrong or possible mistakes ive done.

[danextian]

Hi @Ed_Beach 

There's no flow of relationship from DateTable and Returns tables. The DataTable affects the Orders table only thus your seeing the total count of returns regardless of the year. Does Orders have more than one row per Order ID?