Forum Discussion

Mahmoud_Nasser's avatar
Mahmoud_Nasser
Frequent Visitor
4 years ago

data modeling problem

i want to calculate the sales(subtotals) for top 5 product names but give me the same result   
Data Protection
MattAllington's avatar
MattAllington
Community Champion
4 years ago

Use OrderDetail[SalesAmount] instead of sub total. You can only fi,ter/summarise data by following the arrows in the model. 

Mahmoud_Nasser's avatar
Mahmoud_Nasser
Frequent Visitor
4 years ago

Thanks, Matt 

i measured it by [salesamount] but doesn't give me the same result 

for example total [subtotals] = 115 M  but total [sales amount] = 98 M 

  • MattAllington's avatar
    MattAllington
    Community Champion
    4 years ago

    The formulas add the totals. You need to understand your data better. Pick one invoice and investigate 

    • Mahmoud_Nasser's avatar
      Mahmoud_Nasser
      Frequent Visitor
      4 years ago

      okay, I will do 

      Thanks for help matt