Forum Discussion

Ed_Beach's avatar
Ed_Beach
New Member
3 years ago

Measure values not calculated by table column

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.

Need Help

1 Reply

  • danextian's avatar
    danextian
    Super User
    3 years ago

    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?