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:  Be...
Need Help
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?